Hi,

Can you help me adding the TiketID.

If I add the line: adv.TicketId as TiketNr  I get an error meessage

"All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists."

So.. I think i need to add this in the UNION part ( because without that.. the script is runing)

Thank you.

Sorry to ask.. Can some one please let me know how to run this query?

I am new to this and in learning process.

Hello,

I was able to change the query to use the "Today's date " - 42 by using SET @startdate =(Select Dateadd(day, -42, Getdate())) /* Today minus 6 wekks = 42 days */

but when running the report from the SCOM Console > reporting > Scheduled Reports > it still refers to a fix date in 2009???

Anyway toc change this?

Thanks,

Dom

Hi Kevin . I would like to thank you for this wonderful work for getting the Outage & maintenance report , however it seem that the dynamic group created in the SCOM Console are not visible in this reports. do you have anything on top of your mind which can add that in this report.

Hi Kevin,

i have some small query in SQL query Regarding this line (DATEADD(hh,DATEDIFF(hh,getutcdate(),getdate()),av.RaisedDateTime)) as DownDateTime,
suppose consider raiseddate time is morning 6AM and i am adding 6 hours to the raiseddatetime means how it will be downtime since it may chnage the state @ 8 am means i am running the query @ 10 AM it will show downtime as 4 hours but issue resolved in 2 hours ?