I have update my query.
=iif((Fields!DBName.Value <> "tempdb") OR Fields!State_desc.Value = "ONLINE"
AND IsNothing(Fields!Physical_device_name.Value) AND DateAdd("d", 1, Fields!Last_db_backup_date) < Now(),"Orange", "LightGreen")
Can you please check if the reasoning and query...

Noted.

I was able to export  the AD's  this way
Get-ADUser -Filter *|select GivenName,Name,Enabled,SID | out-file output.txt

How do I remove the headers and make this file into...

This piece of code works perfectly well when I run in powershell-sends an email along with the attachment.But when I schedule it in a task scheduler it does send an...

I need server size difference for any 2 dates which are 30 days apart.
The query posted is giving me an empty set.

The code works.The issues was with the task scheduler.

How do I cc in the above code.Right now I can only send the mail to 1 recipient.I would like ...

I need this to work across all SQLVersions

How I do find all the jobs which have failed today and the failed job when they ran the last time they were scheduled.

Ex 1:All jobs if scheduled today...

This is what I am trying to do.

select sj.name,sj.enabled,sjh.step_id,sjh.message from

sysjobhistory sjh inner join sysjobs sj

on sj.job_id=sjh.job_id

and sj.enabled='1'

In this query result.For every sj.name there will 1 or more sjh.step_id 's and...

Have you tried writing a different SQLAgent task to ensure that you have the task launch under these conditions? <--- What do you mean by this ?

Yes to both powershell...

Can anyone please help fix this ?

Thanks