DIciek asked a question.
Transfer Created Alerts
Hi,
since SLM can only have one Admin or a group Admin email to create alerts, I require a way to transfer the Alerts I have created for a Swiss customer before I exit my position at the end of the year. Any ideas?
Thanks to anyone who replies.
Cheers,
DI
I'm assuming you mean notifications that you create in the Admin Menu in SLM?
If so
-- Get user ids for system users
SELECT UserID FROM SnowLicenseManager.dbo.tblSystemUser WHERE UserName = 'YOUR_USERNAME'
SELECT UserID FROM SnowLicenseManager.dbo.tblSystemUser WHERE UserName = 'DESIRED_USER'
-- Update notifications from one user to another user
UPDATE SnowLicenseManager.dbo.tblNotification
SET UserID = 0 -- Change 0 to the value from Desired User
WHERE UserID = 0 -- Change 0 to the value from Your Username
-- Show all notification in the system
SELECT * FROM SnowLicenseManager.dbo.tblNotification
Hey Dan,
Your database admin will need to run them in SQL Server Management Studio against your SnowLicenseManager database. :)