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:

    help.kaseya.com/.../index.htm

    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;

    help.kaseya.com/.../2668.htm

     

    vBackupLog

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

    Column Name

    Type

    Purpose

    Machine_GroupID

    varchar(201), null

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

    agentGuid

    numeric(26,0), null

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

    machName

    varchar(100), null

    Machine Name used for each agent

    groupName

    varchar(100), null

    Group Name used for each agent

    EventTime

    datetime(3), null

    time stamp when the event was recorded

    description

    varchar(1000), null

    description of the reported task

    durationSec

    int(10), null

    number of seconds the reported task took to complete

    statusType

    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)

    result

    int(10), null

    0: failure

    1: success

    2: archive incomplete

    imageSize

    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#