LogoLogo
3.5.7
3.5.7
  • Introduction
  • Getting started
    • Installation
      • On-premises
        • Single-node
        • Multi-node
      • Azure Market Place
      • AWS Market Place
    • Tutorials
      • Amazon AWS CUR
      • Amazon AWS CUR (Athena)
      • Azure Stack
      • Azure EA
      • Azure CSP
      • Google Cloud
      • VMware vCloud
      • VMware vCenter
    • Concepts
      • User interface
      • Services
    • Releases
      • Upgrading to version 3
      • Known issues
      • Announcements
      • Archive
  • Reports
    • Accounts
    • Services
    • Instances
    • Summary
    • Budget
  • Services
    • Manage
    • Rates
    • Adjustments
    • Subscriptions
  • ACCOUNTS
    • Budget management
  • Data pipelines
    • Extract
      • Configuration
      • Templates
      • Script basics
      • Parslets
      • Subroutines
        • check_dateformat
        • check_dateargument
        • format_date
        • validate_response
      • Language
        • aws_sign_string
        • basename
        • buffer
        • csv
        • clear
        • discard
        • encode
        • encrypt
        • environment
        • escape
        • exit_loop
        • foreach
        • generate_jwt
        • get_last_day_of
        • gosub
        • gunzip
        • hash
        • http
        • if
        • json
        • loglevel
        • loop
        • match
        • pause
        • print
        • return
        • save
        • set
        • subroutine
        • terminate
        • unzip
        • uri
        • var
    • Transform
      • Transform Preview
      • Configuration
      • Language
        • aggregate
        • append
        • calculate
        • capitalise
        • convert
        • copy
        • correlate
        • create
        • default
        • delete
        • environment
        • event_to_usage
        • export
        • finish
        • if
        • import
        • include
        • lowercase
        • normalise
        • option
        • rename
        • replace
        • round
        • services
        • set
        • split
        • terminate
        • timecolumns
        • timerender
        • timestamp
        • update_service
        • uppercase
        • var
        • where
    • Datasets
    • Lookups
    • Metadata
    • Reports
    • Workflows
  • Administration
    • User management
      • SAML2/LDAP
      • Users
      • Groups
    • Notifications
    • Settings
      • Global Variables
  • Advanced
    • Integrate
      • GUI automation
        • Examples
      • API docs
      • Single sign-on
        • Azure-AD
        • Auth0
        • OneLogin
        • ADFS
        • LDAP
    • Security
    • Digging deeper
      • Authentication flows
      • Transformer datadate
      • Dataset lifecycle
      • Config.json
      • Directories
      • Databases
  • Terms & Conditions
  • Privacy Policy
Powered by GitBook
On this page
  • Overview
  • Syntax
  • Details
  • Update a single service
  • Update multiple services using a CSV lookup file
  • Update multiple services using a DSET
  • Examples

Was this helpful?

Export as PDF
  1. Data pipelines
  2. Transform
  3. Language

update_service

Overview

The update_service statement is used to update service descriptions and/or unit labels.

Syntax

update_serviceservice_key[descriptionnew_description][labelnew_label]

update_service using filefile key_col[descriptiondescription_col][labellabel_col]

update_service using dsetkey_col[descriptiondescription_col][labellabel_col]

Details

The update_service statement can:

  • update a single service using a specific key

  • update all services whose keys are present in a DSET or CSV lookup source

Update a single service

update_serviceservice_key[descriptionnew_description][labelnew_label]

The service with a key of service_key is updated with the literal description and label provided.

Update multiple services using a CSV lookup file

update_service using filefile key_col[descriptiondescription_col][labellabel_col]

The file parameter may contain a path component and is considered as relative to the home directory.

All services keys that match values in the key_col column in the CSV called file have their descriptions and/or labels updated with the values in the corresponding description_col and label_col columns in file.

Update multiple services using a DSET

update_service using dsetkey_col[descriptiondescription_col][labellabel_col]

The DSET ID is derived from the key_col column as follows:

  • If not fully qualified then the default DSET is assumed

In either case, whichever is used, or both, of description_col and label_col must be located in the same DSET as key_col

Examples

# Update all services from CSV file
update_service using file "system/lookup.csv" service_key description service_name label unit

# Update specific service
update_service "Small_VM1" description "Small VM 1" label "VM's"
PrevioustimestampNextuppercase

Last updated 5 years ago

Was this helpful?

To update services using a DSET, it must have been previously in order to be used as the lookup source.

If then the DSET is derived from key_col directly

imported
fully qualified