• State Verified Answer
  • Replies 11 replies
  • Answers 1 answer
  • Subscribers 32 subscribers
  • Views 10816 views
  • Users 0 members are here
Options
Related

AD Action Summary Custom Report Request

alain loulie
over 4 years ago

An overview explaining the report you require:
I need a report that creates a summary of AD activity, showing Accounts Created, Accounts Deprovisioned, Computers Created, Groups Created and Groups Modified.
I have reports that will output the information but then I need to use another method to count the number of operations then find another way to send the information.
It would be much easier if a custom report could be created that I could then use the scheduler to send the email with the information.

The report will output the information like this:
Action                                      Count
Accounts Created                    163
Accounts Deprovisioned          431
Computers Created                 133
Groups Created                       361
Groups Modified                      1502

What version of Enterprise Reporter is being used?:
3.1.0.2112

What discoveries have been run?:
AD

Is there a library report that closely matches what you require?:
Not that I have found but I have made one that gathers the information required just doesn't total the numbers. (see above)

What fields are required in the report?:
Accounts Created, Accounts Deprovisioned, Computers Created, Groups Created and Groups Modified

How does the information in the report need to be sorted?:
Just summary totals as shown above

What parameters are required for filtering the report?:
Timeframe selection e.g. Summary between 01/09/2019 and 01/10/2019

How will this report be consumed? For example, will the report be viewed in report display, exported to CSV, or exported to PDF?:
Preferably sent out using the scheduler but otherwise can be report viewer, csv or pdf etc.

Parents Reply Children
  • 0 over 4 years ago in reply to Peter.Hannah

    That is great, fits exactly what I need.

    Do you know if there is a way I can automate this being sent out via email, I have it in a schedule I am just not sure how to have the schedule change the date parameter.

    Basically I would like to send this once a month with the previous month's information which means that the parameter needs to automatically set itself to the 1st of the previous month and the current day.

  • +1 over 4 years ago in reply to alain loulie

    Through the magic of SQL, we could change the report so that it doesn't have parameters for the start and end range but instead automatically report on last month's range.

    That would allow you to un the report anytime in December and get November's results, so on the scheduled report, you would only have to set the Domain and make sure you schedule it after the month you want the results for.  I would suggest if we do this, that we also include the calculated date range in the resultant report, so that you know what dates were actually used.

    When exporting to CSV, you could use the CSV tab in the Report wizard and hide the date columns if wanted as well.

    And just in case you liked this idea, here is the report.

    https://www.quest.com/community/quest/enterprise-reporter/user-cooperation/m/custom-reports/252

    Peter

  • 0 over 4 years ago in reply to Peter.Hannah

    Thank you very much for sorting that Peter, it is exactly what we need.

    Both forms will be excellent for our needs.

    If it is simple to change would it be possible to have the date in UK format or something like this "01 February 2019".

    If it isn't an easy change don't worry I will just add a note to say it is in US format.

    Thanks once again for your help on this

    - Alain

  • +1 over 4 years ago in reply to alain loulie

    For the way I had added the Date range in the report, there is no way to format that combined string into the format you require.

    However, you can replace that string with 2 individual Dates which can be formatted however you like.

    Edit the layout of the report, and remove the calculatedField1 from the layout. Then drag-and-drop the two date fields (Start of Range and End of Range) from the Fields List into the detail header band. 

    Once there, you can change the formatting for each of the dates by selecting each one and clicking the little chevron (>) to change the format string to {0:dd MMMM yyyy}

    Using the layout editor will let you position the controls however you like, as well as change other items like the formatting of the Page footer's date time.

    Peter

  • 0 over 4 years ago in reply to Peter.Hannah

    Perfect all sorted thank you very much for your help