Reporting

SEAD administrators instruction guide

Export information available from the SEAD interface

Cite
Released
13/05/2024

CSV exports

Downloadable CSV exports are available throughout the Administrator Interface for each of the system objects (Projects, Products, Users etc). 

NOTE: Exports are only available in CSV.

export button

Fig. 1. Export button shown throughout object interfaces, at the right of screen

The CSV file will appear on the top right of your screen. Click to open.

downloaded report

Fig. 2. Downloaded report

What export information is available

Table. 1. Export information
Export from viewContains
Projects
  • ID
  • Project name
  • Project Storage Size
  • Organisation
  • Status
  • Start Date
  • End Date
  • Closed Date
  • Description
  • Users (analysts only)
  • Lockup/Restricted 
  • Databricks 
  • Tags
Virtual Machines
  • Name
  • Project
  • Build Date
  • Destroyed Date
  • Status, Assigned To
  • Power State
  • Type
  • Size
  • Version
  • Local Disk Size
Users
  • Username
  • Registered Date (the date they as a person are created in the system)
  • Status
  • Email
  • Phone
  • Organisation
  • Display Name
  • Active VM
  • Tags
Products
  •  Short name
  • Long name
  • Tags
Packages 
  • Name
  • Version

Desktop Sessions

To apply the formulas during exporting, refer to the code on the right hand side of the table

  • Start time

needs conversion   

=DATEVALUE(MID(G4,1,10))+TIMEVALUE(MID(G4,12,8))+(10/24)

when in excel you will then need to format the cells

               ·     right click menu, Format cells...

               ·     pop up box appears, select Time

               ·     select first type and press ok

  • End Time

needs conversion   

=DATEVALUE(MID(G4,1,10))+TIMEVALUE(MID(G4,12,8))+(10/24)

when in excel you will then need to format the cells

                 ·     right click menu, Format cells...

                 ·     pop up box appears, select Time

                 ·     select first type and press ok

  • Duration

needs conversion   

=CONCATENATE(TEXT(INT(D4/1000)/86400,”[hh]:mm:ss”))

*should display correctly so no need to format cells

  • User Name
  • VM Name

Start and end time display in UTC, to convert to AEST (+10) use:

=DATEVALUE(MID(G4,1,10))+TIMEVALUE(MID(G4,12,8))+(10/24)

G4 is the cell with the UTC date/time

Organisations
  • Organisation Name
  • ABN (ABN is included to be the matching key between cloud and Registration Centre)
  • Tags
Action Log
  • Action
  • Object Identifier
  • Status
  • Remarks
  • Initiated By
  • Time Started
  • Time Completed
  • ID
  • Parent ID
  • Child Events