Report on device overview

[nmulder]

I have a department here that wants to use certain items from the device overview list that belong to their department and have them in a custom view. Is there a way to create a custom report to only show the devices that belong to that department?

[nmulder]

This is perfect. Thanks a lot!

[Hemoco]

See this sql code that you can tweak:

Select tblCustDevices.DeviceKey, tblCustDevices.Ipaddress,
tblCustDevices.Displayname, tblCustDevices.Description,
tblCustDevices.Location
From tblCustDevices
Where tblCustDevices.Location = 'my location'