[sims] SIMS Emergency Alert Report

[ldewsnap]

Hi,

 

I was just wondering if there was any way to run a report on the number of times a user has pressed the emergency alert button?

 

Thanks

Lee

[Esteban_Child_of_the_Sun]

run this PowerShell script as a domain user who has SSO into SIMS

Import-Module *Sql* 
$sqlQuery = "SELECT * FROM [sIMS].[sims].[alt_message] where subject = 'Assistance Urgently Required'"
Invoke-Sqlcmd -Query $sqlQuery -ServerInstance “SIMS-01\SIMS2016” -Database “SIMS" | Export-Csv D:\SIMS_Share\sims\Reports\EmergancyAlerts.csv

[EduBadger]

Hi - How did you get on with this in the end ? We're looking at achieving the same.

[Esteban_Child_of_the_Sun]

ESS have since added it in to the standard SIMS reporting engine so you can now write a report in the data area: Communication | Emergency alerts

[EduBadger]

Thats Buddy yes that worked well