SCCM Client Health State

Every SCCM Admin would have been asked this question, "Can you tell me which Client is not communicating back to the primary site server?"
All of us admin would know that a SCCM client is of no use if it does not communicate correctly back to the primary site server.
If it does not communicate, it will be be able to retrieve any machine policy.
If it does not communicate, it will be be able to send back the inventory information back to the Primary Site Server.
And of course the list goes on....

Using the query below, you will be able to do just that.
With the information that is made available, you will then be able to troubleshoot the client that are not working as expected.

SELECT [SMSID]
      ,[FQDN]
      ,[NetBiosName]
      ,[AssignedSiteCode]
      ,[HealthType]
      ,[HealthState]
      ,[HealthStateName]
      ,[ErrorCode]
      ,[ExtendedErrorCode]
      ,[LastHealthReportDate]
      ,substring(OU.System_OU_Name0,15,3) [Site]

  FROM [CM_C00].[dbo].[v_ClientHealthState] CHS
  left join v_R_System VRS on  VRS.Name0 = CHS.NetBiosName
  left join v_RA_System_SystemOUName OU on ou.ResourceID = VRS.ResourceID

order by HealthState desc

Capturing Windows Activation Key by SCCM

Most of the enterprise that are using Windows as the Operating System would most likely be using Microsoft Multiple Activation Keys or MAk for short for licensing.
There maybe a day which come when you may need to figure out how to get the number of clients in your environment that are activated using a particular product key. (This will NOT work for MAK but if needed, you can still use the generated product ID to tied to a valid ID)
This information unfortunately is not readily available in SCCM and would require some work to have it available.

The VBS that has been written below enables you to be able to retrieve the MAK and store it in a registry key (in the script, I have stored it on HKLM\Software\SCCM\ActivationKey).
Once you have this value available, you will be able to by means of SCCM to do a hardware inventory to retrieve the information and format it accordingly for use.
Hopefully this helps anyone who requires this.

Option Explicit 

Const HKEY_LOCAL_MACHINE = &H80000002
Dim objshell,path,DigitalID, Result ,Strcomputer,objregistry,strkeypath,strvaluename,strvalue,strvaluename1
Set objshell = CreateObject("WScript.Shell")
'Set registry key path
Path = "HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\"
'Registry key value
DigitalID = objshell.RegRead(Path & "DigitalProductId4")
Dim ProductName,ProductID,ProductKey,ProductData
'Get ProductName, ProductID, ProductKey
ProductName = "Product Name: " & objshell.RegRead(Path & "ProductName")
ProductID = "Product ID: " & objshell.RegRead(Path & "ProductID")
ProductKey = ConvertToKey(DigitalID) 
ProductData = ProductName  & vbNewLine & ProductID  & vbNewLine & ProductKey
'wscript.echo ProductData

strComputer = "."
Set objRegistry = GetObject("winmgmts:\\" & _ 
    strComputer & "\root\default:StdRegProv")

'Check for the existance of the key and create if it's not found.
strKeyPath = "SOFTWARE\SCCM\"
strValueName = "ActivationKey"
objRegistry.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

If IsNull(strValue) Then

objregistry.CreateKey HKEY_LOCAL_MACHINE,strKeyPath
StrValueName1 = "ActivationKey"

objRegistry.SetStringValue HKEY_Local_Machine, strKeyPath, strValueName1,ProductKey

End If

'Convert binary to chars
Function ConvertToKey(Key)
    Const KeyOffset = 52
    Dim isWin8, Maps, i, j, Current, KeyOutput, Last, keypart1, insert
    'Check if OS is Windows 8
    isWin8 = (Key(66) \ 6) And 1
    Key(66) = (Key(66) And &HF7) Or ((isWin8 And 2) * 4)
    i = 24
    Maps = "BCDFGHJKMPQRTVWXY2346789"
    Do
        Current= 0
        j = 14
        Do
           Current = Current* 256
           Current = Key(j + KeyOffset) + Current
           Key(j + KeyOffset) = (Current \ 24)
           Current=Current Mod 24
            j = j -1
        Loop While j >= 0
        i = i -1
        KeyOutput = Mid(Maps,Current+ 1, 1) & KeyOutput
        Last = Current
    Loop While i >= 0 
    keypart1 = Mid(KeyOutput, 2, Last)
    insert = "N"
    KeyOutput = Replace(KeyOutput, keypart1, keypart1 & insert, 2, 1, 0)
    If Last = 0 Then KeyOutput = insert & KeyOutput
    ConvertToKey = Mid(KeyOutput, 1, 5) & "-" & Mid(KeyOutput, 6, 5) & "-" & Mid(KeyOutput, 11, 5) & "-" & Mid(KeyOutput, 16, 5) & "-" & Mid(KeyOutput, 21, 5)
   
    
End Function

Bridgeways Management Packs

BridgeWays, leading developers in monitoring, reporting and analytics software offers a variety of Management Packs for System Center Operation Manager.

Using BridgeWays Management Packs, you no longer need to monitor and manage other systems and applications using several disparate tools. Monitor your complete IT environment, bringing end-to-end visibility within a single, pane-of-glass view and reducing your total cost of ownership of Microsoft System Center.

In most enterprise there would be  critical in-house custom applications that requires monitoring.

Bridgeways will be able to help you with that by providing you custom management pack solutions. It can be a great solution for companies that are not familiar with System Center Operations Manager

This video shows a case study with BridgeWays Management Packs Dataport.

This video shows the features and benefits that you can expect to reap from using BridgeWays Management Packs.

The complete list of all available management packs offered by Bridgeways is listed below together with the features

NAME	DESCRIPTION	FEATURES
VMware	Stay ahead of the game by monitoring your virtual environment through System Center Operations Manager (SCOM). More Info | Get a Quote | Free Trial	- Efficiently monitor your VM environment from SCOM - Monitor health & performance with top-level views - Manage the growth of your virtual infrastructure while increasing efficiency - See the complete picture of your environment
Oracle Database & RAC	Keep your Oracle Database and Oracle RAC environment fit and healthy by monitoring its performance through System Center Operations Manager (SCOM). More Info | Get a Quote | Free Trial	- Access and process large amounts of data in no time - Evaluate expected performance and service levels - Identify the root causes of problems and find solutions - Ensure consistent high-functionality of the database
Apache HTTP	Monitoring your Apache HTTP Web Server with System Center Operations Manager… just makes more sense! More Info | Get a Quote | Free Trial	- Proactively monitor and minimize your web server’s downtime - Get critical performance metrics all within the System Center Operations Manager console - Detect and resolve issues quickly and accurately - Out-of-the-box reports on the overall health of server
InterSystems Caché	Continue to deliver cost-effective and quality care to your clients by proactively monitoring your InterSystems Caché Database with our Management Pack for System Center Operations Manager (SCOM). More Info | Get a Quote | Free Trial	- Effectively monitor your InterSystems Caché database environment within the System Center Operations Manager console - Single, pane-of-glass view of all available metrics - Monitor key performance metrics
IBM DB2	Simplify your IBM DB2 database monitoring and management. More Info | Get a Quote | Free Trial	- Lower your total cost of ownership - Resolve performance issues before they become critical - Relate incoming data from DB2 and other applications - Resolve problems quickly without downtime
MySQL	Stamp out application database flare-ups by monitoring the health and performance of your MySQL database with System Center Operations Manager (SCOM). More Info | Get a Quote | Free Trial	- Monitoring from the server all the way down to the indexes - Top-level dashboards & detailed performance views all within the System Center Operations Manager console - Quickly and effectively identify the root cause of problems and find solutions
JBoss	Streamline and take control of your JBoss application server management and monitoring through System Center Operations Manager (SCOM). More Info | Get a Quote | Free Trial	- Ensure optimal health and performance - Integrates seamlessly into System Center Operations Manager - Receive information to improve system health - Extensive Knowledge Base Articles to help resolve issues quickly
Apache Tomcat	Get dependable Tomcat services by proactively monitoring your health and performance metrics with System Center Operations Manager (SCOM). More Info | Get a Quote | Free Trial	- Efficiently monitor your Apache Tomcat application server - Spend less time troubleshooting - Ensure more dependable online services - Get alerts on performance issues
IBM WebSphere	Monitor your IBM WebSphere middleware through System Center Operations Manager, and ensure the health and performance of your interconnected business processes. More Info | Get a Quote | Free Trial	- Efficiently monitor your IBM WebSphere’s application server from the SCOM console - Capitalize on the benefits of SCOM by monitoring health and performance metrics - Identify root causes of problems and find solutions
Java Attributes	Get beyond core Java server monitoring and customize with System Center Operations Manager (SCOM). More Info | Get a Quote | Free Trial	- Lower your cost of ownership - Integrate seamlessly with System Center Operations Manager - Performance management for your organizational needs - Out-of-the box availability, performance and alert reports
Oracle WebLogic	Tie your Oracle WebLogic server front end, middle layer, back end and system hardware together within System Center Operations Manager for efficient and cost-effective monitoring. More Info | Get a Quote | Free Trial	- Increase monitoring and management efficiency - Be more proactive by monitoring within a single, centralized framework via SCOM - Monitor key health and performance metrics - Top-level dashboards and detailed performance views

You can contact BridgeWays using the links provided in each products to start a free trial or requests a quote.