Parameters... [cid:[email protected]] Query...
Select DISTINCT sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0 FROM fn_rbac_R_System(@UserSIDs) sys JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID WHERE DisplayName0 like @filterwildcard and fcm.CollectionID=@CollID Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of James Murphy Sent: Tuesday, July 22, 2014 8:55 AM To: [email protected] Subject: [mssms] CM 2012 Reporting Issue Need some assistance. I broke a golden rule and hastily modified one of the CM 2012 built-in reports "Computers with specific software registered in Add Remove Programs" I thought I brought it back to its original state, but apparently am missing something. I was wondering if anyone is aware of a way to 'reinitialize' the built-in reports, or if someone could take a screenshot of the parameters of their working report, that I could re-enter into my non-working report. The attached doc has screenshots of the DataSet0 Properties, Query and Parameters sections. Background: I was trying to troubleshoot why when I run the "Count all instances of software registered in Add or Remove Programs", which reports back the list of software for the selected collection, but when i click the Software Title, which should run "Computers with specific software registered in Add Remove Programs" and give me the list of machines, I was receiving the following error: "Query execution failed for dataset 'DataSet0' error I had come across a couple of posts suggesting modifying the report parameters (http://phyllisinit.wordpress.com/2012/11/13/add-or-remove-program-report-but-in-computers-with-specific-software-registered-ambiguous-column-name-displayname0/) and meant to take a copy of the report first, but as i stated, i hastily edited the original, which now won't run at all. I was thinking of uninstalling/reinstalling my Reporting Services, but thought I would ask here first. thanks, Jim The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
