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

Subscribe to our Newsletter

Let us keep you posted on product updates, news, and market insights that help you build a more productive organization.


    By subscribing I allow InfraSight Labs to store and process my personal data according to our Privacy Policy

    Supercharge your organization with IT inventory!

    vScope is trusted by companies worldwide, spanning various industries, to enhance IT collaboration and elevate quality standards.

    Ready to experience the difference? Share your contact details, and we’ll connect with you soon!

    Related posts

    Improve IT Service Management: How IT inventory supports you working in a service desk

    February 27th, 2024|Comments Off on Improve IT Service Management: How IT inventory supports you working in a service desk

    BLOG Improving your IT Service Management: How IT inventory helps those working in Service Desk The Service Desk is the IT department's primary interface with the business. It is to a Service

    • 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.6 May 27, 2024 Bugs & Improvements Approve proxies before being used in Discovery Allow user to edit value(s) in List field type in IT Services Optimized stitched

    • 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