All about Microsoft Endpoint Manager
  • Home
  • SCCM
    • Collections
    • OS Deployment
    • Troubleshooting Tips
    • Scripting
      1. PowerShell
      2. VB Script
    • SCCM Tools
  • SCCM Reports
  • Intune
  • About Author
Wednesday, 3 March 2021

Tags: not in V_R_system

configmgr(SCCM) report for mismatch of computers in Configmr

Posted on January 3, 2010 by Eswar Koneti | 0 Comments | 67 Views
select CS.name0 as 'PC name', WS.LastHWScan as 'Last HW scan Date' from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_WORKSTATION_STATUS WS on CS.resourceID = WS.resourceID Where CS.resourceID not in (select R.resourceID from v_R_System R)
Read more »

Eswar Koneti

Looking for Consulting services?

Awards

  • Latest
  • Popular
  • Comments
  • Did you miss to download your samples from Technet Gallery Here is how you can do it.

    Did you miss to download your samples from Technet Gallery Here is how you can do it.

    February 27, 2021
  • Using PowerShell – Retrieve the o365 audit logs for SharePoint sites

    Using PowerShell – Retrieve the o365 audit logs for SharePoint sites

    February 9, 2021
  • SCCM Collection for AAD joined devices (co-managed)

    SCCM Collection for AAD joined devices (co-managed)

    February 5, 2021
  • How to disable Firewall and network protection notifications using Microsoft Intune

    How to disable Firewall and network protection notifications using Microsoft Intune

    January 29, 2021
  • SCCM ConfigMgr report for local admins and local group members

    SCCM ConfigMgr report for local admins and local group members

    March 9, 2017
  • Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

    Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

    March 25, 2010
  • SCCM Configmgr Troubleshooting Client software update issues

    SCCM Configmgr Troubleshooting Client software update issues

    April 7, 2015
  • SCCM report/collection for computers with Internet Explorer with different versions

    April 21, 2010
  • Eswar Koneti hi Bob, Here is how you can download the samples from Techne
  • Eswar Koneti Hi Bob, Here is how you can download the samples from Techne
  • Bob Fitz Hey, Could you share the updated link to the source file "RD
  • Bob Fitz I know this is an old article. But wondering if the report i

.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 7,118 other subscribers

@eskonr on Twitter

Tweets Eswar

All Rights Reserved

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

Archives

.

© Copyright 2009-2021 Eswar Koneti , All rights reserved.