DASH User Action Report helps user to accumulate and organize all DASH activities along with details of user.
This report is enabled with AMPS 3.0 release.
SCCM users can generate this report by following below steps :
- Expand Monitoring node and select overview and then Reporting.
- Click on ‘Report Manager’ Link .
- And click on “ConfigMgr_<siteCode>” Folder . Create a new Folder named “DASH Reports”.
- Expand Reporting node and click on Report and select ‘Create Report’ and provide the name of report as ‘DASH User Action Report’ and path as ‘DASH Reports’ in Create Report Wizard. Select close on Create Report Wizard and Report builder will start where user can create the report query and its parameter.
- Creating DataSets:
- Create a new dataset. Click on ‘Add DataSet’.Rename the name as ‘DASHUserActionLogs’ and select “Use a dataset embedded in my report” and select the Datasource from dropdown menu. Select ‘Query Type’ as Text and place the below query in “Query” text box.
SELECT [ComputerName0],[Creation_Date0],[EventDetails0],[RecordID0],[Severity0],[SiteCode0],[Username0] FROM[CM_<site Code>].[dbo].[v_R_DASHUserActionLogs_2_0_0] WHERE ( (@Severity = 0) OR (@Severity = 1 AND Severity0 = 'Informational') OR (@Severity = 2 AND Severity0 = 'Warning') OR (@Severity = 3 AND Severity0 = 'Error') )AND Username0 = @Login AND ( (@DateRange = 0) OR (@DateRange = 1 AND Creation_Date0 >= DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0)) OR (@DateRange = 2 AND Creation_Date0 >= DATEADD(dd,DATEDIFF(dd,0,GETDATE())-30,0)) OR (@DateRange = 3 AND Creation_Date0 >= DATEADD(dd,DATEDIFF(dd,0,GETDATE())-90,0)) OR (@DateRange = 4 AND Creation_Date0 >= DATEADD(dd,DATEDIFF(dd,0,GETDATE())-365,0)) )
- Create a new dataset. Click on ‘Add DataSet’. Rename the name as ‘Users’ and select “Use a dataset embedded in my report” and select the Datasource from dropdown menu. Select ‘Query Type’ as Text and place the following query in “Query” text box.
SELECT DISTINCT[LogonName] FROM [CM_<siteCode>].[dbo].[v_Admins]
- Creating Parameters:
@Login:
- Expand the parameters and delete default parameters.
- Click on “Add Parameters…”
- Provide name as “Login” and prompt as “Users”
- Click on Available values and select ‘Get values from query’. Select Dataset as Users (created in step 😎 and ‘value field’ and ‘label field’ as “logonname”.
@Severity:
- Click on “Add Parameters…”
- Provide name as “Severity” and prompt as “Severity”
- Click on Available values and select “Specific Values” and specify following pair of values :
Label | Value |
<All Values> | 0 |
Informational | 1 |
Warning | 2 |
Error | 3 |
@DateRange:
- Click on “Add Parameters…”
- Provide name as “DateRange” and prompt as “Date Range”
- Click on Available values and select “Specific Values” and specify following pair of values:
Label | Value |
<All Values> | 0 |
During Today | 1 |
During Last 30 Days | 2 |
During Last 90 Days | 3 |
During Last 365 Days | 4 |
- Click on Table or Matrix option from center pane of Report Builder and select the dataset ‘DASHUserActionLogs’ created in step 5. Select all columns for final report and rename the header of selected columns as below:
[Creation_Date0] - > Date Time (UTC)
[Username0] -> Modified By
[Severity0] - > Severity
[EventDetails0] -> Event Details
[SiteCode0] -> Site Code
[ComputerName0] -> Resource Name
[RecordID0] -> Record Id.
Design header of the report and description like SCCM reports.
- Save the report.
- Expand DASH Category under Report Node and select ‘DASH User Action Report’ and run the report.
- Report will prompt user to select user from “Users” dropdown, select severity from “Severity” drop down and select a date range from “Date Range” drop down.
Note : Replace <siteCode> to appropriate sitecode.
