Notification

Icon
Error

Limiting a Windows report to servers

Posted: Tuesday, September 22, 2015 4:13:46 PM(UTC)
Susan.A

Susan.A

Member Administration Original PosterPosts: 1,535
3
Like
To limit any Windows report to servers only (and not list workstations), do the following:
  • Hit the pencil shaped edit button next to the report under Reports\View All Reports.
  • Double-click on the tblComputersystem database table in the table list on the right to add the table to your report.
  • Double-click on the tblDomainroles database table in the table list on the right to add the table to your report.
  • In the visual representation of the report in the upper section of the report builder, tick the Domainrolename field in tblDomainroles.

    Limiting a Windows report to servers

  • In the Criteria column of the tblDomainroles.Domainrolename expression, add the following:
Code:
In ('Standalone Server','Member Server','Backup Domain Controller','Primary Domain Controller')
SystemsIT
#1SystemsIT Member Posts: 18  
posted: 8/9/2016 7:58:15 PM(UTC)
Very nice.

Do you have the list of items that can populate the char field?

You list

Member Server','Backup Domain Controller','Primary Domain Controller

I know there is DNS and DHCP, what about other roles like file / IIS and so on?
arobinson@mlgw.org
#2arobinson@mlgw.org Member Posts: 1  
posted: 8/31/2016 6:40:02 PM(UTC)
How do you only include servers that have been active during the last 30 days?
James.W.
#3James.W. Member Posts: 6  
posted: 9/27/2016 8:24:22 PM(UTC)
What would the statement be to only include non-servers
James.W.
#4James.W. Member Posts: 6  
posted: 1/20/2017 2:16:28 PM(UTC)
I need this one as well. I need to report only workstations and laptops without a particular software.
FixitDave
#5FixitDave Member Posts: 49  
posted: 5/17/2017 10:39:52 AM(UTC)
I use the following to limit to servers;

tsysOS.OScode Like '%s'
FixitDave
#6FixitDave Member Posts: 49  
posted: 5/17/2017 10:41:14 AM(UTC)
Originally Posted by: James.W. Go to Quoted Post
What would the statement be to only include non-servers


Use the code from my last post but use "not like" instead of "like"
klaus
#7klaus Member Posts: 14  
posted: 4/3/2019 9:48:07 AM(UTC)
Originally Posted by: arobinson@mlgw.org Go to Quoted Post
How do you only include servers that have been active during the last 30 days?


and tblassets.lastseen > dateadd(dd, -30, getdate())
JacobH
#8JacobH Member Posts: 170  
posted: 4/4/2019 2:39:32 PM(UTC)
errr

I always do this for getting servers only:

Code:

Where tblComputersystem.Domainrole > 1


or alternatively,

Code:

where tsysos.osname like 'Win 2%'


that's just me though.

Active Discussions

Lansweeper Remove all users from old domain
by  cmuter   Go to last post Go to first unread
Last post: 9/20/2019 8:03:58 PM(UTC)
Lansweeper Static IP Address
by  cycleheat  
Go to last post Go to first unread
Last post: 9/20/2019 4:07:16 PM(UTC)
Lansweeper Bitlocker Encryption Recovery Key no information found
by  Stephane   Go to last post Go to first unread
Last post: 9/20/2019 2:26:19 PM(UTC)
Lansweeper InTune Scanning Issues
by  Esben.D  
Go to last post Go to first unread
Last post: 9/20/2019 12:34:59 PM(UTC)
Lansweeper Office 365 scanning issues
by  Esben.D   Go to last post Go to first unread
Last post: 9/20/2019 12:23:30 PM(UTC)
Lansweeper Hard Drive Tracking - Start to Finish
by  Lone Jedi  
Go to last post Go to first unread
Last post: 9/19/2019 8:11:56 PM(UTC)
Lansweeper Lansweeper Reporting Old Assets as New
by  Jpatterson   Go to last post Go to first unread
Last post: 9/19/2019 12:52:14 PM(UTC)
Lansweeper Cannot edit a ticket anymore
by  Esben.D  
Go to last post Go to first unread
Last post: 9/19/2019 12:32:42 PM(UTC)