Hello
Our HP SIM agents refuses to install if not SNMP is ready and running. I've been trying whit lots of different Queries to get collections of servers which do not have the SNMP component installed.
I have a query to check if the service is present AND running, but I can not manage to get a collections of the servers that do not have the service at all (no SNMP components installed).
Do you have any suggestions of what I'm doing wrong here? I tried this one, which obviously failed:
select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name != "SNMP Service"
Not exactly sure what servers is picked up, but it is definitely most of the servers. It should be the other way around, as most have the service installed.
Our HP SIM agents refuses to install if not SNMP is ready and running. I've been trying whit lots of different Queries to get collections of servers which do not have the SNMP component installed.
I have a query to check if the service is present AND running, but I can not manage to get a collections of the servers that do not have the service at all (no SNMP components installed).
Do you have any suggestions of what I'm doing wrong here? I tried this one, which obviously failed:
select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name != "SNMP Service"
Not exactly sure what servers is picked up, but it is definitely most of the servers. It should be the other way around, as most have the service installed.