All collections of a specific machine

[wmmayms]

This report will show you all the collections that a specific computer is member of.

This is how it could look:

 

To Create this report:

1. Create a new report and give it a good name

2. Paste the following code:

 

SELECT

b.CollectionID,

b.Name

 

FROM

v_FullCollectionMembership a,

v_Collection b

 

WHERE a.CollectionID = b.CollectionID

AND a.Name = @computer

 

ORDER BY b.name

 

 

3. Click on the prompts button

4. Create a new prompt and give it the name: "computer"

5. Enter a prompt text

6. Provide the following SQL Statement:

 

SELECT

ResourceID,

Netbios_Name0

 

FROM

v_R_System

 

ORDER BY Netbios_Name0

 

Should look like this:

 

7. Click OK everywhere

 

You are all done. HF with the report!

[boognish]

This report will show you all the collections that a specific computer is member of.

 

 

ResourceID,

Netbios_Name0

 

 

 

Thanks!! I had to remove the ResourceID from the prompt to get the report to return the results.

[axejuve]

ThankS!