HI ,

My requirement is to send  Closed tickets details to the concern team (NOC) manager.I have already have one runbook which will send all open tickets details to the concern team.

=========

$securePassword = ConvertTo-SecureString "Lumeris@123" -AsPlainText -force
$credential = New-Object System.Management.Automation.PsCredential("test\administrator",$securePassword)

Invoke-Command -ComputerName scsm2.test.local -ScriptBlock{

                Import-Module SMLets

                $AfterDate = (get-date).AddHours(-2160).ToString(yyy-MM-dd HH:mm:ss)
Get-SCSMIncident -CreatedAfter $AfterDate | select ID,Title,Description,Priority,Urgency,Impact,TierQueue,Classification,Status,CreatedDate,LastModified,AssignedTo,AffectedUser

} -Credential $credential  | select ID,Title,Description,Priority,Urgency,Impact,TierQueue,Classification,Status,CreatedDate,LastModified,AssignedTo,AffectedUser | export-csv C:\SCO\Automation\AllIncidents.csv -NoTypeInformation

====================

Please let me know how to setup custom report (Support group like NOC) in the same way.

Do you want to use Sql Server reporting services?

I thing Power shell is best and need to modify the code

==========

$securePassword = ConvertTo-SecureString "Lumeris@123" -AsPlainText -force
$credential = New-Object System.Management.Automation.PsCredential("test\administrator",$securePassword)

Invoke-Command -ComputerName scsm2.test.local -ScriptBlock{

                Import-Module SMLets

                $AfterDate = (get-date).AddHours(-2160).ToString(yyy-MM-dd HH:mm:ss)
Get-SCSMIncident -CreatedAfter $AfterDate | select ID,Title,Description,Priority,Urgency,Impact,TierQueue,Classification,Status,CreatedDate,LastModified,AssignedTo,AffectedUser

} -Credential $credential  | select ID,Title,Description,Priority,Urgency,Impact,TierQueue,Classification,Status,CreatedDate,LastModified,AssignedTo,AffectedUser | export-csv C:\SCO\Automation\AllIncidents.csv -NoTypeInformation

==========

Did you check Andreas script?

https://gallery.technet.microsoft.com/SCSM-Mail-Notification-c217a8dc

You can edit this script for getting closed incidents.

And I think you can also trigger this script both task scheduler and custom workflow (you can do it with Authoring tool)

Frat

• Edited by Firat YASAR 17 hours 57 minutes ago

Did you check Andreas script?

https://gallery.technet.microsoft.com/SCSM-Mail-Notification-c217a8dc

You can edit this script for getting closed incidents.

And I think you can also trigger this script both task scheduler and custom workflow (you can do it with Authoring tool)

Frat

• Edited by Firat YASAR Wednesday, September 02, 2015 1:20 PM

Did you check Andreas script?

https://gallery.technet.microsoft.com/SCSM-Mail-Notification-c217a8dc

You can edit this script for getting closed incidents.

And I think you can also trigger this script both task scheduler and custom workflow (you can do it with Authoring tool)

Frat

• Edited by Firat YASAR Wednesday, September 02, 2015 1:20 PM

Did you check Andreas script?

https://gallery.technet.microsoft.com/SCSM-Mail-Notification-c217a8dc

You can edit this script for getting closed incidents.

And I think you can also trigger this script both task scheduler and custom workflow (you can do it with Authoring tool)

Frat

• Edited by Firat YASAR Wednesday, September 02, 2015 1:20 PM