Limiting a Windows report to servers

[Susan_A]

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')

[JacobH]

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]

I use the following to limit to servers;

tsysOS.OScode Like '%s'

[James_W_]

I need this one as well. I need to report only workstations and laptops without a particular software.

[James_W_]

What would the statement be to only include non-servers

[FixitDave]

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]

How do you only include servers that have been active during the last 30 days?

[klaus]

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]

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?