Create a Custom Report using SQL to find all devices with software installed from a certain publisher and then list the device name, software,publisher,version?
I need to create a custom report to grab the information stated in the question. When I try and use the report wizard the output only allows for the devices that have software installed by the publisher and then it lists all installed patches and software which is too much.
Any suggestions?
2 Comments
[ + ] Show comments
-
Do you want all titles from the given publisher? - chucksteel 3 years ago
-
Yep! Everything by that publisher that has installed software on the server. - Jekkyll 3 years ago
-
There is a field "Is a Patch" that might help you filter out some of those. - JordanNolan 3 years ago
-
I just looked in all the fields in the create a report wizard and was unable to find "Is a Patch". - Jekkyll 3 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
