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

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

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: 

Forum Posts

Sign in/Join

Only Windows Servers?

I'd like to create a report which ONLY lists computers which have a Windows Server OS installed (2003, 2008, 2008 R2, 2012, 2012 R2, etc). All I really need to have is the asset name, and the OS version installed. The pre-defined asset lists always...

sailor by • Engaged Sweeper
  • 7000 Views
  • 1 replies
  • 0 kudos

Resolved! How do I exclude more than 1 asset type in report?

When I exclude one the code isWhere tsysAssetTypes.AssetTypename != 'Monitor' And tblState.Statename = 'Active'Order By AssetType, tblAssets.AssetNameAnd it excludes MonitorBut when I add another one more to the Or.. it looks likeWhere (tsysAssetTy...

bmbarnett by • Engaged Sweeper III
  • 6543 Views
  • 2 replies
  • 0 kudos

Filter by OS Windows 10

I have a report that is supposed to list all the windows 10 machines in our environment. We have two new windows 10 machines that are not showing up on that report, but are showing up on the new computers detected. The report (See below) is filtered ...

tcrook by • Engaged Sweeper
  • 13409 Views
  • 8 replies
  • 0 kudos

Report on Random KB Articles

Trying to setup a generic report query, where i am able to punch in the specific KB's to determine which assets are missing the KB's with their OS version. We are running version 6.0.100.x and currently trying to report on (CVE Microsoft Equation Ed...

ipirzada by • Engaged Sweeper
  • 5410 Views
  • 2 replies
  • 0 kudos

Workstation SCCM Report

You can edit this one for servers as well... i'm too lazy to change the query aliases Add the following to file/registry scanning:%windir%\CCMSetup\ccmsetup.exeHKLM/SOFTWARE\Microsoft\CCM\CcmEval LastEvalTimeHKLM/SOFTWARE\Microsoft\CCM\CcmEval Las...

jacob_bks by • Champion Sweeper
  • 9834 Views
  • 2 replies
  • 0 kudos