Service Versions Challenges

[D.Dean]

I have been tasked with writing an analysis with the following information for some of our “Tools”

If the service exists
Version of the Service

I am using this in each analysis property, in most cases…

IF (exists service whose (service name of it as string as lowercase = "servicename")) THEN (state of it & " - " & version of it as string) of service whose (service name of it as string as lowercase = "servicename") ELSE "Not Installed"

This works perfect in most cases. Then some not mentioned vendor failed to put the version number in the service application. This generates the “Singular expression refers to nonexistent object” error. So for that vendor tool I just manually edited the relevance to say “Version Unavailable”.

The final challenge, some services have names that are different for each customer (We are an MSP). For example, the SNOW MID server service name is snc_mid_MSP_MidServer_ABC and the only piece of that name that exists on all customers is the snc_mid_. I can get the data if the service is running, even if it produces an error (Because there are more than one service name begining in snc_mid) but I can’t get the version number.

I got the data by using the “contains snc_mid” (Again, I manually entered the text “Version Unavailable”)

IF (exists service whose (service name of it as string as lowercase contains "snc_mid")) THEN (state of it & " - " & "Version Unavailable") of service whose (service name of it as string as lowercase contains "snc_mid") ELSE "Not Installed"

Two questions…

Is there a way I can use “if exists version then list it” instead of manually editing the relevance and only display the version if it exists?

Is there a way to pull the actual service name using the “contains” statement then getting the version of the service using the full name?

[JasonWalker]

The simplest way is probably to pull a plural result (where 0 results are also ok)

q: (service names of it, states of it, versions of it) of services whose (service name of it starts with "BES")
A: BESClient, Running, 10.0.7.52

If you have to use your result format (because some other tool expects it that way) I think you should be able to use

q: if exists services whose (service name of it starts with "BES") then (service name of it & " - " &  state of it & " - "  & (version of it as string | "Version Unavailable")) of services whose (service name of it starts with "BES") else "Not Installed"
A: BESClient - Running - 10.0.7.52

The pipe operator I used there is a handy error-handler shortcut in case you expect a possible error -

(version of it as string | "Version Unavailable" )

If the expression on the left of the pipe has an error, the result on the right is substituted instead. Both sides of the pipe require the same type - so I had to cast the version as string so it matched the type of the “Version Unavailable” message.

[D.Dean]

Well am finally calling it a night but I will run with this tomorrow.

@JasonWalker As always, thanks for your help

[D.Dean]

In the analysis is there a way to display each result in the result screen instead of “multiple results”

[JasonWalker]

You’d need to concatenate the plural results into a single string, like

q: concatenation "; " of (service name of it & " - " &  state of it & " - "  & (version of it as string | "Version Unavailable")) of services whose (service name of it starts with "BES" or service name of it starts with "MS")

A: BESClient - Running - 10.0.7.52; MSDTC - Stopped - Version Unavailable; MSiSCSI - Stopped - Version Unavailable

[D.Dean]

Can I use a new line instead of a "; "
concatenation “%0d%0a” of

[JasonWalker]

You could, but I don’t know whether newlines are going to show up the way you want in the Console.

[D.Dean]

Correct, it didn’t.
So much for an easy read in the console. It really does not matter much, the lady that writes our reports will separate it in SQL and display it all nice and pretty in our reports.

Again, thanks for all of your help