Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

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: 2,077 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