Connect to a custom SQL database

vScope’s custom SQL integration allows teams to further centralize assets, reports and documentation about its IT.

vScope 3.17 introduces a new, flexible integration that to a greater extent allows teams to centralize asset documentation and reports on the same platform. The Custom SQL integration enables an even more flexible inventory than the very popular Excel import which is widely used to import tags to various assets from .xlxs files.

Unlike the Excel import, Custom SQL is part of vScope’s discovery. This means that you can also create new assets and customize the format of tags. Furthermore, you can configure your Custom SQL queries to run automatically whenever you want using discovery schedules.

Fetch warranty dates, costs, notations, new assets and more

With Custom SQL it’s easy to get additional data into vScope, which is currently not available in existing integrations. Fetch warranty status from a warranty management system, costs from a BI system, or SLAs from your service desk. If you currently document assets in an asset management system there are good chances that you can collect them into vScope using the Custom SQL integration.

It’s easy to get started!

You can use Custom SQL to connect vScope to a SQL database, such as Microsoft SQL or MySQL, to fetch new assets and tags. vScope needs to be able to connect to a database using an account with reading permission. You will receive direct feedback in vScope if something’s wrong. Now you are ready to run a custom SQL query to fetch a table from the database.

Notice that the resulting table must include sufficient identifiers for vScope to stitch them with existing assets, or add them as new. Once a connection is established you can use vScope’s Tag manager to customize which columns to extract to tags.

When configured, vScope will automatically fetch values, update information and create new assets from the database.

What’s next?

If you are already running vScope, you should follow this guide to setup a Custom SQL integration. If you are currently not aboard the vScope train we can arrange a demo to show how your team can benefit from centralizing IT asset reporting and documentation.

Don’t hesitate to contact us with any feedback or questions regarding extended IT inventory.

Contact Customer Success

PUBLISHED

May 5, 2021

Author Soroush Pourhadi

Anton Berghult

Product Marketing

Stars and review
vScope is a Great Place to Work

Related posts

  • vScope logo on a blue background

vScope 3.29.0

February 7th, 2024|Comments Off on vScope 3.29.0

vScope 3.29 3.29.1February 5, 2024What's newCustom Tag Collection from Azure RMEnhance your cloud environment inventory in vScope by creating custom tags with values sourced directly from your Azure RM environment. This

  • Powershell in vScope

Introducing PowerShell: Custom inventory of Registry Keys

January 30th, 2024|Comments Off on Introducing PowerShell: Custom inventory of Registry Keys

PRODUCT UPDATE Windows PowerShell and Just Enough Administration: Unleashing New Dimensions in IT Inventory with vScope With PowerShell, you can now enjoy a more flexible and customizable approach to documenting and reporting on your

  • vScope By InfraSight Labs

What is CMDB: A comprehensive guide to configuration management database

November 28th, 2023|Comments Off on What is CMDB: A comprehensive guide to configuration management database

BLOG What Is a CMDB: A Comprehensive Guide to Configuration Management Database The Configuration Management Database (CMDB) is a crucial component of IT Service Management (ITSM). It serves as a central repository