Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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: 352 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

Tags

Classifications

Public