Need a SQL View or SQL Read to pull up the Admin Email variable.
I've tried All Listed Database views (Agent Procedure Runable) but was unable to locate the respective data.
Anyone with KServer access and SQL knowledge able to find out the 'View' I should be using. If it doesn't exist is there a SQL Read command which will get this info?
I'd normally just grind until I find the answer but I don't have KServer access, let alone SQL access, and I've searched for quite some time without much luck.
Thx in advance.
Also if you suggest, "use managed variables", I'll hit you.
not sure if this is what you are looking for or not;
VSA user Email address
This will give you the admin email address for the VSA admin that scheduled/executed the agent procedure
That would be #vAgents_Machines.adminContact# I think.
Love your work, huge fan, Thx!
Also... May or may not be of use to you.
Here is my (current) library of kaseya Database views.
Sheet2 gives you the procedure you can use to obtain a .txt file with real data. This way you can see exactly which data corresponds to a database view when called in an agent procedure
Great work HardKnoX
jorigas If you also want the database table it is called dbo.users.
The column would be ContactEmail.