Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2015 05:13 PM
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')
Labels:
- Labels:
-
Report Center
8 REPLIES 8

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-04-2019 03:39 PM
errr
I always do this for getting servers only:
or alternatively,
that's just me though.
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-17-2017 11:39 AM
I use the following to limit to servers;
tsysOS.OScode Like '%s'
tsysOS.OScode Like '%s'

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2017 02:16 PM
I need this one as well. I need to report only workstations and laptops without a particular software.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2016 09:24 PM
What would the statement be to only include non-servers

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-17-2017 11:41 AM
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"

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2016 07:40 PM
How do you only include servers that have been active during the last 30 days?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-03-2019 10:48 AM
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())

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-09-2016 08:58 PM
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?
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?
