This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Report on device overview

nmulder
Engaged Sweeper

‎12-17-2012 10:46 PM

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?
Labels:
0 Kudos
2 REPLIES 2
nmulder
Engaged Sweeper

‎12-19-2012 09:10 PM

This is perfect. Thanks a lot!
0 Kudos
Hemoco
Lansweeper Alumni

‎12-19-2012 07:33 PM

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'
0 Kudos

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now