ITNinja

Greetings,

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:

PAT-W2K8-Recommended
PAT-W2K8-Critical
PAT-W2K3-Recommended
PAT-W2K3-Critical

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