Jump to content


Kevin79

Report Subscription - date

Recommended Posts

I have a subscription to a report for Endpoint Protection that shows infected computers. The report only shows the date range from when the report was initially created. How do I get it to show a "floating" range (the past 10 days)?

Share this post


Link to post
Share on other sites


You will need to edit the report and setup the prompts to have the floating 10 days.

Share this post


Link to post
Share on other sites

Edit your prompts queries and added Getdate and Datadiff to them to get the results that you are looking for.

Share this post


Link to post
Share on other sites

In the datasets for the prompts.

Have you every edited a SSRS report before? if not then you should look at that first. there are a few good books on the subject. Mine being one of them.

Share this post


Link to post
Share on other sites

No I have not. Do I need to book about SQL reporting or Configuration Manager reporting?

Share this post


Link to post
Share on other sites

Personally I would look for one on CM reporting. Why because it will show you the details on using SSRS with CM.

 

This is the one I wrote so I'm bias but I think it is good and it will work for all version of CM. https://www.amazon.com/System-Configuration-Manager-Reporting-Unleashed/dp/0672337789/

 

 

 

 

Share this post


Link to post
Share on other sites

If you love it, please review it on Amazon. Heck, I'm sure that @Niall, would be ok with you reviewing it here too.

If you have question about it, I'm always around.

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...