10 Replies - 758 Views - Last Post: 26 July 2014 - 05:19 PM Rate Topic: -----

#1 JJu-256  Icon User is offline

  • D.I.C Head

Reputation: -6
  • View blog
  • Posts: 115
  • Joined: 21-December 11

DB Job Description: Do you know how to go about this?

Posted 23 July 2014 - 09:07 AM

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 this is my thought , not for sure how it works?

1. Tenable line of product with python API--Identitfied
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.

Skills
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.

Is This A Good Question/Topic? 0
  • +

Replies To: DB Job Description: Do you know how to go about this?

#2 smendoza88  Icon User is offline

  • D.I.C Head

Reputation: 12
  • View blog
  • Posts: 64
  • Joined: 13-July 11

Re: DB Job Description: Do you know how to go about this?

Posted 23 July 2014 - 10:54 AM

Sounds like a etl process that runs. I have one that polls a ftp. Grabs the files, cleans up the data based biz rules, spits rejected records into another table, load good records into a staging table. Another process loads the data from the staging table into production.
Was This Post Helpful? 0
  • +
  • -

#3 JJu-256  Icon User is offline

  • D.I.C Head

Reputation: -6
  • View blog
  • Posts: 115
  • Joined: 21-December 11

Re: DB Job Description: Do you know how to go about this?

Posted 23 July 2014 - 11:45 PM

View Postsmendoza88, on 23 July 2014 - 10:54 AM, said:

Sounds like a etl process that runs. I have one that polls a ftp. Grabs the files, cleans up the data based biz rules, spits rejected records into another table, load good records into a staging table. Another process loads the data from the staging table into production.


This is extraction, transformation and loading the good data to the database so that it could be used accordingly. The process has to be repeatable and automated say every day or every week. I am trying:

1.
a. plan ( This will involve the methodology fully documented)
b. design the process
2. Implement
3. Test
4. Deploy (pre-stage then prod)

Do you have anymore input here. Thanks.
Was This Post Helpful? 0
  • +
  • -

#4 smendoza88  Icon User is offline

  • D.I.C Head

Reputation: 12
  • View blog
  • Posts: 64
  • Joined: 13-July 11

Re: DB Job Description: Do you know how to go about this?

Posted 24 July 2014 - 02:48 PM

Nope, you described what you need to do. My only 2 cents would be to test with bad data too, that way you can see what happens. Does it blow up? does it get loaded in the staging table? and so on.
Was This Post Helpful? 0
  • +
  • -

#5 JJu-256  Icon User is offline

  • D.I.C Head

Reputation: -6
  • View blog
  • Posts: 115
  • Joined: 21-December 11

Re: DB Job Description: Do you know how to go about this?

Posted 24 July 2014 - 03:35 PM

Thanks for helping me out.....
Was This Post Helpful? 0
  • +
  • -

#6 JJu-256  Icon User is offline

  • D.I.C Head

Reputation: -6
  • View blog
  • Posts: 115
  • Joined: 21-December 11

Re: DB Job Description: Do you know how to go about this?

Posted 26 July 2014 - 10:53 AM

I will like to let you know what I am trying to achieve in a step-by-step fashion.

1. Asset Identification:
We try to inventory the assets: It is like head count with the help of tools.
2. Tools are Tenable (A) and SCCM (B )
3. We proceed to reconcile the assets found.
*************Reconciling the asset is actually its own process**********
4. We must produce matching asset by data manipulation: We compare system A and B and take out the union as reconciled. Otherwise we proceed to the next level.
5. Verifying the unreconciled assets to see the possibility of validating them with other systems (VCM or ECM) if possible.
6. If they can in fact be verified then they can be validated as reconciliation candidates.
7. If in fact any asset or computer can't be validated then it can't be reconciled.
8. All the reconciled asset will then be massaged and cleaned up to go into DB.
9. The ultimate goal is to develop a method of getting update from discovery in an automatic fashion.

Is this comparison, updating and transformation in an automatic fashion to a DB possible ?
One more thing tenable uses Python API. Thanks.

This post has been edited by JJu-256: 26 July 2014 - 10:54 AM

Was This Post Helpful? 0
  • +
  • -

#7 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 6111
  • View blog
  • Posts: 23,671
  • Joined: 23-August 08

Re: DB Job Description: Do you know how to go about this?

Posted 26 July 2014 - 02:30 PM

So, does this mean you took the job?
Was This Post Helpful? 0
  • +
  • -

#8 JJu-256  Icon User is offline

  • D.I.C Head

Reputation: -6
  • View blog
  • Posts: 115
  • Joined: 21-December 11

Re: DB Job Description: Do you know how to go about this?

Posted 26 July 2014 - 02:33 PM

View PostJackOfAllTrades, on 26 July 2014 - 02:30 PM, said:

So, does this mean you took the job?


I am not sure until I know for sure how to go about it.
Was This Post Helpful? 0
  • +
  • -

#9 macosxnerd101  Icon User is offline

  • Self-Trained Economist
  • member icon




Reputation: 10823
  • View blog
  • Posts: 40,349
  • Joined: 27-December 08

Re: DB Job Description: Do you know how to go about this?

Posted 26 July 2014 - 02:39 PM

So is this an interview question? If you don't have the job, I take it this isn't a project for which you are getting paid.
Was This Post Helpful? 0
  • +
  • -

#10 JJu-256  Icon User is offline

  • D.I.C Head

Reputation: -6
  • View blog
  • Posts: 115
  • Joined: 21-December 11

Re: DB Job Description: Do you know how to go about this?

Posted 26 July 2014 - 05:15 PM

If I am getting paid you won't make any input I understand that.
Are you making any input into this. That is all I am looking for.
Was This Post Helpful? 0
  • +
  • -

#11 macosxnerd101  Icon User is offline

  • Self-Trained Economist
  • member icon




Reputation: 10823
  • View blog
  • Posts: 40,349
  • Joined: 27-December 08

Re: DB Job Description: Do you know how to go about this?

Posted 26 July 2014 - 05:19 PM

No, the reason I'm asking is because it sounds like an interview question. If you had taken the job, you wouldn't have replied to JackOfAllTrades as you did. If you can't handle the interview questions, we're not here to help on those. Companies have those for a reason- to determine who they do (and don't) want to hire. As such, I'm closing this thread.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1