1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

SQL Reports on WMI Data

Avatar
Sarah Boatwright
Updated

Hi, we created a WMI scanner to inventory Windows Store Apps as described in the KB and now want to report on it. For example, report which computers have Skype.

Can anyone help with the joins to query data from Computers and the WMI scanner table?

 

select
Computers.Name as "Computer Name"
,Computers.ADDescription
,[Computers].[CurrentUser]
,[WMIScanner_68_View].Name
,[WMIScanner_68_View].Version
from Computers c
join [WMIScanner_68_View] wmi on wmi.?=c.?
where [WMIScanner_68_View].Name = 'Microsoft.SkypeApp'

1

Comments

2 comments
Date Votes
  • Avatar
    Colby Bouma

    WMI scanners are not easy to integrate into SQL reports. I recommend creating a basic report if possible.

     

     

    1
  • Avatar
    Sarah Boatwright

    I had tried Basic first and got an error that WMI columns couldn't be used in Basic reports with another column I had chosen, but now I see how it will work.  Thanks!

    1