Submit a ticketCall us
Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Number of CPU Core SQL report

Number of CPU Core SQL report

Table of contents
Created by Malik Haider, last modified by Diane R. Medroso on Aug 23, 2018

Views: 2,239 Votes: 2 Revisions: 6

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.NodeID, 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.NodeID, N.Caption, IP_Address,  Status
Order By
N.Caption, IP_Address,  Status

 

6. Go to Field Formatting Tab > Select the NodeID then tick on Hidden Field.

 

Report Writer.JPG

 

7. Click Preview.

 

Last modified

Tags

Classifications

Public