I tried that already.Did not work

PS H:\> $File = gci \\abcd\efgh\ijkl | select -last 1
PS H:\> $From = "abcd@gmail.com"
PS H:\> $To = "defg@gmail.com"
PS H:\>...

It did not work

$File = "gci \\abcd\efgh\ijkl | select -last 1"
$From = "abcd@gmail.com"
$To = "efgh@gmail.com"
$Attachment = $File
$Subject = "Here's the Email Subject"
$Body =...

I tried that..it does not work.
It starts searching from the directory I am running the code from.
Send-MailMessage : Could not find file 'H:\files_06-04-2018_02-40-08.html'

My files exists in...

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...