Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn more about our patch management solution.

 

Home > Success Center > Network Performance Monitor (NPM) > Number of CPU Core SQL report

Number of CPU Core SQL report

Table of contents
Created by Malik Haider, last modified by MindTouch on Jun 23, 2016

Views: 84 Votes: 2 Revisions: 5

Overview

This article provides steps to build a number of CPU Core SQL report.

Environment

NPM version 11.0 or later

Steps

1. Open the Orion Report Writer.

2. Click Start > All Programs > Solarwinds Orion > Advanced Feature > Report Writer > New.

 

3. Name The Report  as required.

4. Click on SQL Tab > Paste the below SQL Query.

5. Select N.Caption, IP_Address,   Status,  COUNT(DISTINCT CPUIndex) As "Number Of Cores"
FROM CPUMultiLoad_Detail CPU WITH(NOLOCK)
JOIN Nodes N ON CPU.NodeID = N.NodeID
GROUP BY
N.Caption, IP_Address,  Status 
Order By
N.Caption, IP_Address,  Status  

 

6. Go to Fild Formatting Tab > Select the below option.

 

7. Click Preview.

 

Last modified
23:14, 22 Jun 2016

Tags

Classifications

Public