Node Count Per Site/Subnet/Location
Hello All,
Appreciate any help and/or advice...
We have a very large envirnoment (over 30,000+ end points)
We are in need of a report(with drilldown abilities) that will report the number of managed nodes in a given location(subnet, Organizational unit, location, etc) with a drill down that shows a list (computer names) of systems for that location.
The issue is we have rolled out about 90% of the agents, but we need to work toward the full 100% but in order to turn it over to the local sites IT teams we need be able to provide them with an accurate list of systems that are reporting into our NS servers so they can make an effort to get the missing systems..
Due to our complex network infrastructure with Trusted, semi-trusted, and untrusted vlans we are unable to successfully enable network discovery and get 100% coverage.
Have been on the phone with Symantec Tech Support, consultants, but still do not have what we are looking for.
We thought we had it when we used the task server summary report.. But when you drill down on the report the ROW X of XXXX doesn't equal the client count on the Task server summary report (this is a "Known Issue" from Symantec tech support)
I am new to the entire SMP platform, I have basic knowledge of SQL, SQL queries, and custom report builder - But any help would be greatly appreciated.
Thanks

Comments
So..
So help me understand.
1. Report that lists all Locations.
2. Clicking on a Location lists all Computers in that location
Right?
I'm not sure how you defined locations. Are you seeing the list you expect in vAssetLocation (SELECT val.* FROM vAssetLocation val)? If so that's your first report. When you create the drilldown, you will make sure that the Location you click on in the report populates the following query:
SELECT vc.[Guid] as '_ItemGuid',vc.Name,vc.[OS Name] FROM vComputer vc JOIN vAssetLocation val ON val._AssetGuid=vc.[Guid] WHERE val._Location='%YourParameterFromYourDrilldown%'
Does this work for you?
Mike Clemson, Senior Systems Engineer
Intuitive Technology Group -- Symantec Platinum Partner
Would you like to reply?
Login or Register to post your comment.