Would anyone be able to provide the SQL Statement to generate the following report.

I need to generate 3 seperate report based on locations for server and the patch labels assigned to them.

For example:

I have a Label called, "Boston Servers" This Label contains all the servers at my Boston facility.

I have a the following patch labels that are used to detect patches assigned to these labels:


I would like to generate a report, sorted by Server Name that list all the patches from these labels and their status. from my understanding this is considered a hybrid report since it needs to pull information from both a "computer label" and a "patch label"

Any guidance is greatly appreciated.

Thank Yoiu
0 Comments   [ + ] Show Comments


Please log in to comment

There are no answers at this time
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.


Answer this question or Comment on this question for clarity