lpor

Why not delete them if you are never going to use them?

I need to be able to sort IPSLA operations on custom properties.

Yea been there but support tell me it should work in a Workgroup, but I don't believe they have tried it to a remote instance. It will be a pain if I have to install a local instance.

"The SQL statement you use for this query must return a numerical value, not a varchar." I need to return an error with the associated batch job information. The SQL User Experience monitor will only allow a numerical value to be returned.

Thanks to everyone for answers, this is what I tried --- I am using SNMP polling, the next poll time was in the past, Poll Now made no difference, restart of SNMP service made no difference but a restart of all Orion services solved the issue. I noticed that Solarwinds Collector data Processor didn't stop and had to kill…

Hi Thanks for the reply but now looks like I need to do this from the SQL table as the log file can have hundreds of entries for a single error. The SQL table entry ties the errors to a transaction ID so I need to pull that with each error. I need some sort of script I think to do this, I will update if I get a solution. I…

Hi David I don't think it is, as they are in a workgroup the user would be local to the PAS server. I looked in SQL Security - Logins and tried to add the user from the PAS server but that server does not appear as a Location so it will not let me add it. Not sure if this is normal in Workgroups or particular to this…

Answer from support: It isn't possible to monitor a table within an SQL DB with SAM at the moment. You could use a tool like Powershell to run SQL queries against the database and then use a Powershell Monitor with SAM to record the result of these queries. Now the above is only a suggestion as we do not provide PS scripts…