MSSQL databases not getting discovered

Karthik37
Tera Contributor

Hi Folks,

We are trying to discover our MSSQL databases and while doing the discovery we are able to discover the instances, DBs for few servers and for few servers we are able to discover only the instances and not DBs. While checking the pattern we get the below error. Any suggestions on this error?

WMI query on host xx.xx.xx.xx failed. query: SELECT Name FROM Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabases error: Invalid class

WMI query on host xx.xx.xx.xx failed. query: SELECT Name FROM Win32_PerfFormattedData_MSSQLMSSQLSERVER_MSSQLMSSQLSERVERDatabases error: Invalid class

 

Little more detail:

This is getting executed in pattern "MSSql DB On Windows" and step "Get list of db from wmi" under identification for MS SQL server.

 

10 REPLIES 10

Hi @hz2 ,

 

For this error, May I know how you resolved it ?