SOLVED Software inventory - query

[Lukas Novy]

Hello, I would need to create list (excel table) of software inventory (Add or remove programs) from specific device collection where are all devices of my organization. I tried use to tool CmPivot by InstalledSoftware command and yes it works but for online devices only. I would need to get it from all devices including which are offline.
Built in reports isn´t so good and there isn´t report for view all software and all clients. I think I have to create my own WQL query report or something like that. Can you help me please?

And before that, Can I run Software Inventory Cycle on device collection (for all devices inside)? Isn´t can be some performance issue in sccm? I want to have software inventory up to date as possible.

Thanks, Lukas

 

[Garth]

Start with the built in reports, find the one that gives you the closest to what you need and make changes to it.