Kaseya Community

List of Variables

  • I have been looking for a list of all the variables, as I cannot find a full list. 

    I have found a list of Patch Management variables, see below.  However, I need a much larger list as I am attempting to right some script to resolve some functionality issues we are having. 

    Specifically in regard to Backup, i.e. backup file location, date/time stamp, GUID, etc.  Any help would be appreciated.

    Patch managment

    • #vPatchConfiguration.FileSourceUNCPath#   - Patch File Source UNC Path

    • #vPatchConfiguration.FileSourceLocalPath#   - Patch File Source Local Path

    • #vPatchConfiguration.FileSourceMachineId#   - Patch File Source Machine Id

    • #vPatchConfiguration.RebootAction#      - Patch Reboot Action

    • #vPatchConfiguration.contactName#

    • #vPatchConfiguration.contactEmail#

  • Hello Scurrier.

    Did you look at help - "Database Views" are a huge ressource ...

  • Hey - check out the database views... Start here:


    If you click on any of the main views - you'll see the variables you can get access to. There's a lot in there(!)

    So... #vMachine.OSType# would return 'XP' on a Windows XP machine (what you see in Quick View.)

    Hope that makes sense - super powerful capability.

    Update: Another post with some examples: http://community.kaseya.com/xsp/f/28/t/11113.aspx

    [edited by: Kerry DeVilbiss at 2:06 PM (GMT -7) on 4-30-2012] Added reference to another article
  • I'm not sure how useful these are going to be but I think this is what you were looking for;




    Logs each alert sent out via email. Multiple rows per machine

    Column Name




    varchar(201), null

    A concatenated representation of the machine id and the group id it is associated with.


    numeric(26,0), null

    A globally unique identifier for a machine ID.group ID account and its corresponding agent.


    varchar(100), null

    Machine Name used for each agent


    varchar(100), null

    Group Name used for each agent


    datetime(3), null

    time stamp when the event was recorded


    varchar(1000), null

    description of the reported task


    int(10), null

    number of seconds the reported task took to complete


    int(10), null

    0: full volume backup

    1: offsite replication (obsolete)

    2: incremental volume backup

    3: offsite replication suspended (obsolete)

    4: offsite replication skipped because backup failed (obsolete)

    5: folder full backup

    6: offsite folder suspended (obsolete)

    7: differential volume backup

    8: folder incremental backup

    9: folder differential backup

    10: volume verification

    11: folder verification

    12: volume backup skipped because machine offline

    13: folder backup skipped because machine offline

    14: Informational

    15: Diff or Inc ran as full vol when last full vol not found

    16: Diff or Inc ran as full folder when last full folder not found

    17: volume backup cancelled

    18: folder backup cancelled

    19: volume image conversion (in KBU 3.0)

    20: volume synthetic full backup (in KBU 3.0)

    21: folder synthetic full backup (in KBU 3.0)


    int(10), null

    0: failure

    1: success

    2: archive incomplete


    float(53), not null

    The size of the backup.

  • Thank you all for the information, it is very useful, however I am looking for anything that may not be listed in the help file related to backups.  I am looking to pull Image Location, Date/Time of last backup, Name of last backup file, etc.  I know the information has to be stored in the database somewhere, I just need to be able to access as a variable for scripting purposes.  I am not sure if I am making this any clearer, but I hope this helps you understand what I am trying to find

    I.e. Patch managment

    #vPatchConfiguration.FileSourceUNCPath#   - Patch File Source UNC Path

    • #vPatchConfiguration.FileSourceLocalPath#   - Patch File Source Local Path

    #vPatchConfiguration.FileSourceMachineId#   - Patch File Source Machine Id

    • #vPatchConfiguration.RebootAction#      - Patch Reboot Action

    • #vPatchConfiguration.contactName#

    • #vPatchConfiguration.contactEmail#