Forum Discussion
Hi Lucjad, Just as a clarifying question in the datasource when you test Active Discovery does the resource you are attempting to monitor appear in the list?
Yes, but the DataSource I am looking for these services is SQLServer Services not the Microsoft Windows Services.
I am trying to set it up for non-admin service account. Changed SDDL permissions to have the same access as the local admin service account but Logic Monitor’s Active Discovery doesn’t seem to be picking anything up.
after adding permissions I performed WBEM test and non admin account reads all the sql services from admin account but Logic Monitor’s active discovery doesn’t work on this.
- JosiahBenoit2 months agoNeophyte
What "AppliesTo" statement is on your datasource? The reason I have asked is that I have had to manual add resources in the past. My example would be I have a single "Postgres" Database and that took some work to add to LogicMonitor.
- lucjad2 months agoNeophyte
Applies to: hasCategory(“MSSQL”) && !hasCategory(“WSFC_VNN”)
but for non-admin service account other devices don’t pick any information in Logic Monitor about SQL Server Services.
I am looking for not doing it manually because I have about 200ish servers to do it for. After setting things right for non-admin service account I should be able to run active discovery and get the monitoring for this datasource. It works for collector because it has local admin service account but it doesn’t work for non-admin account. Logic Monitor has documentation but I guess it’s not complete.
- Mike_Moniz2 months agoProfessor
but the DataSource I am looking for these services is SQLServer Services not the Microsoft Windows Services.
What do you mean by this? Is the SQLServer services you want not listed when you look at Services in Computer Management? SQLServer services is a type of windows service if I understand your situation.
Yes...
So when you run an Autodiscover test it DOES shows the MSSQL Services but it does not show as an instance in the Resources page?
- lucjad2 months agoNeophyte
I see the services on the server itself. Auto discovery in Logic Monitor doesn’t recognize these services from the server. The datasource is not even listed under the server in Logic Monitor.
- lucjad2 months agoNeophyte
I am aware of Computer Management and what it offers. Yes, the services are not shown in Logic Monitor under the device. There must be some misconfiguration. Please see my below reply.