RE: [mssms] CM 2012 Reporting Issue

2014-07-22 Thread Marcum, John
51 AM To: mssms@lists.myitforum.com Subject: RE: [mssms] CM 2012 Reporting Issue BTW The simplest way to reset the Reports is to re-install the reporting point. There are other ways but this is the simplest way. BBTW, A copy of all the original RDL is sit on your RP server under the Reports fo

RE: [mssms] CM 2012 Reporting Issue

2014-07-22 Thread Garth Jones
BTW The simplest way to reset the Reports is to re-install the reporting point. There are other ways but this is the simplest way. BBTW, A copy of all the original RDL is sit on your RP server under the Reports folder. Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 ww

RE: [mssms] CM 2012 Reporting Issue

2014-07-22 Thread James Murphy
Thanks Daniel! that worked...now back to my original troubleshooting... From: dratl...@humana.com To: mssms@lists.myitforum.com Subject: RE: [mssms] CM 2012 Reporting Issue Date: Tue, 22 Jul 2014 13:02:07 + Parameters… Query… Select DISTINCT sys.Netbios_Name0, fcm.SiteCode

RE: [mssms] CM 2012 Reporting Issue

2014-07-22 Thread Daniel Ratliff
Parameters... [cid:image001.png@01CFA58B.9D0AC680] 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