December 2, 2009 at 4:12 am
Morning,
I am a SCOM Admin and I am trying to create some custom reports in SQL 2008. i am new to SQL and was hoping someone could at least guide me in the right direction. I have a report that pulls data from the SCOM DB. Basically you can select the start and end date Ex: 11/1/09 - 11/30/09. What i need to be able to do is have the option of excluding weekends and only during core hours. So when the report pulls data it gives me down time during the core hours only. Now like i said i am new to SQL so bare with me here. 🙂 The guy that made the original report said i needed a SQL admin to assist me........hence the reason i came here. Any help or guidance is appreciated.
Thanks
Chris
December 2, 2009 at 12:43 pm
I am no SSRS expert, but it sounds like you would need a separate query to exclude weekends. I am not sure how it could be implemented in the same report or if it would have to be implemented in a separate report. Maybe if this thread was moved into either one of the SQL 2008 forums or maybe the Business Intelligence forum for 2005 someone more knowledgeable on it could pipe in with suggestions.
Can you post the query statement for the current report? Someone might be able to suggest where to modify it to exclude weekends. It would most likely be a date function used on the datetime field to exclude records where the date landed on a Saturday/Sunday.
Joie Andrew
"Since 1982"
April 30, 2011 at 10:03 pm
This website might be able to assist you:
May 2, 2011 at 10:01 am
With you current date range, try to filter your dataset by using the functions WeekDay() and TimeValue() in the filter expression.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply