→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Susan_A
Lansweeper Alumni
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:
In ('Standalone Server','Member Server','Backup Domain Controller','Primary Domain Controller')
8 REPLIES 8
JacobH
Champion Sweeper III
errr

I always do this for getting servers only:


Where tblComputersystem.Domainrole > 1


or alternatively,


where tsysos.osname like 'Win 2%'


that's just me though.
FixitDave
Champion Sweeper
I use the following to limit to servers;

tsysOS.OScode Like '%s'
James_W_
Engaged Sweeper II
I need this one as well. I need to report only workstations and laptops without a particular software.
James_W_
Engaged Sweeper II
What would the statement be to only include non-servers
James.W. wrote:
What would the statement be to only include non-servers


Use the code from my last post but use "not like" instead of "like"
arobinson
Engaged Sweeper
How do you only include servers that have been active during the last 30 days?
klaus
Engaged Sweeper III
arobinson@mlgw.org wrote:
How do you only include servers that have been active during the last 30 days?


and tblassets.lastseen > dateadd(dd, -30, getdate())
SystemsIT
Engaged Sweeper III
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?