ETL with some programming in it.

Viewing 1 post (of 1 total)
  • Author

  • jumezurike

    My boss is asking me to reconcile a list of IT assets provided by discovery scans with the data base of IT assets that exist in the Configuration Management Data Base. We need the contractor to create a repeatable process by which discovered assets can be added to the DB.

    Is there anyone out there that has done this before? Fpr a start this is my thought , not for sure how it works? I can’t envision the practical approach.

    1. Tenable line of product with python API–Identitfied as the scan engine
    2. Extracting the discovered asset from the repository using python (extracting data via API)
    3. Create a SQL database TABLE for the records which could be accessed with access front end.
    4. Automate the process (ETL). Is there any adapter that can help with this without manual update.

    My biggest is how to bring it all together in a practical sense.

    1. Powershell
    2. Python
    3. Text manipulation (I can deal with this one well)
    4. JSON

    OTHER tools
    3. ServiceNow

    If you can put the idea together if you have done this before thanks.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

External Sharing and Guest User Access in Microsoft 365 and Teams

This eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

You will learn:

  • Who should be allowed to be invited as a guest?
  • What type of guests should be able to access files in SharePoint and OneDrive?
  • How should guests be offboarded?
  • How should you determine who has access to sensitive information in your environment?

Sponsored by: