Is there a method to sort the default "Config Change Report" by Node Name or IP Address?
I can not seem to figure out how to accomplish this relatively simple task.
TY
I would like to be able to sort the "Policy Report" by Node Name. It's hard to find a node among 1000+ nodes. I get tired of scrolling and my vision goes blurry.
The new Compliance Report in NCM 7 has sorting capabilities, based on all columns.
We don't have this for the Config Change Report (but it's sorted by default based on node name in the Win32 interface) but we plan to improve this in the future.
Update:
Post yesterday's upgrade to NCM 7.0.1 the Config Change Report had a sorted alpha listing.
However there was a downside the report included the entire config, not just the 5 lines pre and post the changes. Net result a prettier report, but very very large.
Looking for that portion of the report config now....
The settings for Config comparison are stored in server's NCM settings.
Configs
Config Comparison
Display __ number of lines before and after each change.
Our setting for Display is 3 which is currently being ignored by the printed reports.
Also we lost the grey shaded printed output indicating where there are printed differences. This reflects the web based green and pink.
Hi
You could use SQL to pull the data out and then sort by NodeCaption and then display the amount of lines you want
Kind Regards
James
Hi You could use SQL to pull the data out and then sort by NodeCaption and then display the amount of lines you want Kind RegardsJames
James,
I have no SQL programing skills; just a simple and over-commited network engineer. Why would I wish to do this when the application should provide the functionality?
if that was the case then we would all be out of a job ;-)
I have attached an example SQL query that you can add to report writer and it would be good to start learning SQL as that is the basis of Orion frontend, as all the fancy widgets are SQL queries basically speaking. The bit I have highlighted in bold is the name of my policy, so change that to your one.
SELECT[Nodes].NodeCaption, [PolicyCacheResults].PolicyName, [PolicyCacheResults].RuleName, 'Errorlevel' = CASE [PolicyCacheResults].ErrorLevelWHEN '0' THEN 'Info'WHEN '1' THEN 'Warning'WHEN '2' THEN 'Critical'ELSE 'Not-Defined'END,[Nodes].Building, [Nodes].MachineTypeFROM solarwinds_ncm.dbo.Nodes RIGHT JOIN solarwinds_ncm.dbo.PolicyCacheResults ON solarwinds_ncm.dbo.[Nodes].NodeID = solarwinds_ncm.dbo.[PolicyCacheResults].NodeIDWHERE [PolicyCacheResults].ReportName = 'UK Standards'AND [PolicyCacheResults].IsViolation = 'True'AND [Nodes].NodeCaption != ''ORDER BY [Nodes].Building, [PolicyCacheResults].RuleName, [Nodes].NodeCaption
My responsibilities covers, for 5000 desktops, all network infrastructure (routers, switches, firewalls, network load balancers, Cisco and non-cisco wireless controllers, and IOS based access points); 145 Microsoft and non - microsoft servers (AD and all of the other Microsoft applications, and associated scripting); Fiber channel switches and storage. I have yet to include our vm environment and managing the security for all of this. One of my side jobs is network management and monitoring.
I have no intention or requirement to learn SQL. If we purchase an application for network management and performance monitoring and if I request an enhancement to make my job easier and possibly for others then I feel safe in doing so.
Thanks for providing your script, I'll give it a go when the opportunity provides.
