Report Information: Removing Duplicate Netbios Names/computers in a ConfigMgr Report.
Running the following report category/Name "Software - Companies and Products; Computers w/specific software registered in Add Remove Programs" entered the proper parameters (values). The report displays duplicate machines, how do I remove the duplicate machines from this report? I have both Delete Inactive Client & Delete Obsolete Client configured in Site Maintenance if that matters? How do I remove the duplicate machines from this report?
Thank you for your assistance...
April 9th, 2010 5:50pm
Start by cloning the report (right-click clone) and give it a different name so in case you mess up you didn't mess up the original.
Then two possible changes...
Change Select sys.netbios_name0 to have distinct, to get rid of duplicate identical rows, like Select Distinct sys.netbios_name0
the other change would be to change from v_r_system sys to instead use from v_r_system_valid sys
Those are relatively easy ways to reduce the # of duplicates, and also to reduce the # of obsolete computers show up in reports.Standardize. Simplify. Automate.
Free Windows Admin Tool Kit Click here and download it now
April 9th, 2010 6:00pm
Thank you for your response...
It worked perfect!!
April 9th, 2010 7:13pm