Does it use any functions for RBAC? Check out Garth Jones posts about modifying those reports, they are a bear.
I usually recreate the report and queries from scratch. -Daniel Ratliff -----Original Message----- From: Nick [[email protected]<mailto:[email protected]>] Sent: Thursday, January 30, 2014 08:56 PM Eastern Standard Time To: [email protected] Subject: [mssms] Customizing default reports in SCCM 2012 Hi all, Been a while since I’ve been active on the forum. I’ve copied the default report “List of assets by compliance state for a configuration item in a configuration baseline.” I need to add a few columns from the v_r_user view and maybe some additional computer information to the report so that it is more useful for the end-users. I’ve tried a few things like adding a simple JOIN to the main select statement and even editing the temp table that is created in the report but no matter what, I continue to be prompted to “Define Query Parameters”. No matter what I do from this point on, either most of the fields in the data set disappear, or if I select the check boxes next to all of the fields in the “Define query parameters” dialog, click OK, then Cancel to the prompt, the report eventually errors out with: “Query execution failed for dataset 'DataSet0'. (rsErrorExecutingCommand)” Any ideas? Should it be this hard to add a column to the default reports? I feel like I’m making huge strides in reporting with 2012 but this has me stumped. -Nick- 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.
