SQL version detection and reporting in SCCM
Ioan Popovici
4413

Hi Ioan,

I have checked the InventoryAgent.log file…

See below — Any suggestions? Looks like it isn’t detecting SQL?

Collection: Namespace = \\.\root\cimv2; Query = SELECT __CLASS, __PATH, __RELPATH, PropertyIndex, PropertyName, ServiceName, SqlServiceType, IsReadOnly, PropertyNumValue, PropertyStrValue, PropertyValueType FROM SQL_2000_And_2005; Timeout = 600 secs. InventoryAgent 04/04/2017 10:37:51 248 (0x00F8)
Collection: Class “SQL_2000_And_2005” does not exist. InventoryAgent 04/04/2017 10:37:51 248 (0x00F8)

Collection: Namespace = \\.\root\cimv2; Query = SELECT __CLASS, __PATH, __RELPATH, PropertyIndex, PropertyName, ServiceName, SqlServiceType, IsReadOnly, PropertyNumValue, PropertyStrValue, PropertyValueType FROM SQL_2008; Timeout = 600 secs. InventoryAgent 04/04/2017 10:37:49 248 (0x00F8)
Collection: Class “SQL_2008” does not exist. InventoryAgent 04/04/2017 10:37:49 248 (0x00F8)

Collection: Namespace = \\.\root\cimv2; Query = SELECT __CLASS, __PATH, __RELPATH, PropertyIndex, PropertyName, ServiceName, SqlServiceType, IsReadOnly, PropertyNumValue, PropertyStrValue, PropertyValueType FROM SQL_2012; Timeout = 600 secs. InventoryAgent 04/04/2017 10:37:59 248 (0x00F8)
Collection: Class “SQL_2012” does not exist. InventoryAgent 04/04/2017 10:37:59 248 (0x00F8)

Collection: Namespace = \\.\root\cimv2; Query = SELECT __CLASS, __PATH, __RELPATH, PropertyIndex, PropertyName, ServiceName, SqlServiceType, IsReadOnly, PropertyNumValue, PropertyStrValue, PropertyValueType FROM SQL_2016; Timeout = 600 secs. InventoryAgent 04/04/2017 10:37:59 248 (0x00F8)
Collection: Class “SQL_2016” does not exist. InventoryAgent 04/04/2017 10:37:59 248 (0x00F8)

Collection: Namespace = \\.\root\cimv2; Query = SELECT __CLASS, __PATH, __RELPATH, PropertyIndex, PropertyName, ServiceName, SqlServiceType, IsReadOnly, PropertyNumValue, PropertyStrValue, PropertyValueType FROM SQL_2014; Timeout = 600 secs. InventoryAgent 04/04/2017 10:37:59 248 (0x00F8)
Collection: Class “SQL_2014” does not exist. InventoryAgent 04/04/2017 10:37:59 248 (0x00F8)

Like what you read? Give Andre Schoeman a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.