lucastee Posted October 30, 2012 Report post Posted October 30, 2012 Hi all, Probably just a quick one but I cannot for the life of me find if this report exists or I am able to create it using SQL Report Builder. Essentially, I'd like to create a report that allows me to enter a device name and it will return the list of collections that it belongs to. e.g Entered: Device Name: PC1 Returned: Collections: Windows 7 PCs, Power-Saving Excluded. I'd like to be able to run this in the event that a PC needs to be moved. Looking through each device collection until I find each record is not ideal as I will have as many as 50 collections to look through. Any advice/suggestions would be appreciated. Quote Share this post Link to post Share on other sites More sharing options...