(imported topic written by SystemAdmin)
Im trying to get a list i can import into Excel of all services and all the information for each
when i use the line below, it very ugly when importing into excel
(service name of it, display name of it, state of it, start type of it, login account of it) of services as string)
when I run the line below I get mostly and
When I run it on my PC with the Relevance checker it looks fine
what am i doing wrong ?
concatenation "; " of unique values of ((service name of it, display name of it, state of it, start type of it, login account of it) of services as string)
what im actually trying to do is get a list of services that aren’t using standard login accounts
like LocalService and LocalSystem, but even if i filter out those I still need to import it
(imported comment written by BenKus)
Perhaps some of the services don’t have one of the attributes? What error did you get?
Maybe try this slightly modified version:
concatenation "; " of unique values of (((service names of it, display names of it, states of it, start types of it, login accounts of it) of services) as string)
And to exclude the LocalSystem and LocalService:
concatenation "; " of unique values of (((service names of it, display names of it, states of it, start types of it, login accounts of it) of services whose (login account of it as lowercase does not contain “localservice” AND login account of it as lowercase does not contain “localsystem”)) as string)
Ben
(imported comment written by SystemAdmin)
Thank you Ben
I found that “is not contained by” seems to shorten up my query
concatenation "; " of unique values of ((service name of it, display name of it, state of it, start type of it, login account of it) of services whose ((login account of it as lowercase is not contained by “|nt authority\networkservice|nt authority\localservice|nt authority\localsystem|.\aspnet|localservice|localsystem|”))as string)