(imported topic written by SystemAdmin)
I wrote the following properties to retrieve information from an IIS Metabase
Q: ((name of it) & " - " & (value whose (identifier of it as integer = 1015) of it)as string) of keys whose (exists name of it as integer) of key “LM/W3SVC” of metabase
Q: ((value whose (identifier of it as integer = 4001) of it)as string) of key “LM/W3SVC” of metabase
Q: ((name of it) & " - " & preceding text of last “%00” of((value whose (identifier of it as integer = 2021) of it)as string)) of keys whose (exists name of it as integer AND exists value whose (identifier of it as integer = 2021) of it) of key “LM/W3SVC” of metabase
Q: ((name of it) & " - " & preceding text of last “%00” of((value whose (identifier of it as integer = 1023) of it)as string)) of keys whose (exists name of it as integer) of key “LM/W3SVC” of metabase
Q: ((name of it) & " - " & ((value whose (identifier of it as integer = 3001) of key “root” of it)as string)) of keys whose (exists name of it as integer) of key “LM/W3SVC” of metabase
Q: ((name of it) & " - " & ((value whose (identifier of it as integer = 6011) of key “root” of it)as string)) of keys whose ((exists name of it as integer AND exists value whose (identifier of it as integer = 6011) of key “root” of it) of it) of key “LM/W3SVC” of metabase
Q: ((name of it) & " - " & preceding text of last “%00” of((value whose (identifier of it as integer = 2021) of it)as string)) of keys whose (exists name of it as integer AND exists value whose (identifier of it as integer = 2021) of it) of key “LM/W3SVC” of metabase
Now it has ben requested that I condense this down into a single property so that you get something like this, which is a combination of the first four properties.
Q: (((name of it) & " - " & (value whose (identifier of it as integer = 1015) of it) as string) & (" - Server Binding - " & preceding text of last “%00” of((value whose (identifier of it as integer = 1023) of it)as string)) & (" - LogFile - " & (((value whose (identifier of it as integer = 4001) of it)as string) of key “LM/W3SVC” of metabase) & “” & “W3SVC” & (name of it)) & (" - Path - " & ((value whose (identifier of it as integer = 3001) of key “root” of it)as string))) of keys whose (exists name of it as integer) of key “LM/W3SVC” of metabase
A: 1 - Default Web Site - Server Binding - :80: - LogFile - C:\WINDOWS\system32\LogFiles\W3SVC1 - Path - c:\inetpub\wwwroot
A: 1830613563 - OPUS WebServices - Server Binding - 162.130.123.219:80: - LogFile - C:\WINDOWS\system32\LogFiles\W3SVC1830613563 - Path - D:\Inetpub\OPUS_WS
A: 1975023959 - Uptime - Server Binding - 162.130.123.222:80: - LogFile - C:\WINDOWS\system32\LogFiles\W3SVC1975023959 - Path - D:\Inetpub\Uptime
A: 2064447704 - OLD OPUS Production - Server Binding - 162.130.123.211:8000: - LogFile - C:\WINDOWS\system32\LogFiles\W3SVC2064447704 - Path - D:\Inetpub\OPUS
A: 407083821 - FSSP Production - Server Binding - 162.130.123.217:80: - LogFile - C:\WINDOWS\system32\LogFiles\W3SVC407083821 - Path - D:\Inetpub\FSSP
A: 902667181 - OPUS Production - Server Binding - 162.130.123.211:80: - LogFile - C:\WINDOWS\system32\LogFiles\W3SVC902667181 - Path - D:\Inetpub\OPUS
This works ok but I having difficulties with the last 2 properties because they don’t always exists and the 6011 property is actually one key deeper in the metabase. I have been chewing on it the last couple of days and can’t seem to get by it.
Has anyone done something similar where they need to pull anumber of properties for each machine in a single property, but only the ones that exist?