Sign in
 
HomeLibraryLearnDownloadsRepositoryCommunityForumsBlog
Script Center >
> 
> 
Retrieve Inventory Information from the user and export them to Excel sheet

Answered Retrieve Inventory Information from the user and export them to Excel sheet

  • Tuesday, February 12, 2013 6:16 PM
     
     
    Sign In to Vote
    0

    Hi All,

    I am trying to get some inventory details like the following from 100 users.I want to collect all the information in excel sheet .

    I am new to Wsh scripting but have working knowledge on Vbscript

    This is my plan:

    1)vbs/wsh script will be in shared server and the user must invoke/run the script through cmd prompt with username as argument

    2)The script should now get all the listed inventory details and export the information to Inventory excel sheet present in the same shared server

    3)At the End of the day,all the users inventory information should be present in the excel.

    Is this possible?Can any one help me to achieve this.

    The following are Inventory details :

    1. Computer type Desktop/laptop?
    2. Hardware model(for example Lenovo T500,T420S)
    3. Processor speed in GHZ
    4. HD space in GB
    5. Memory modules RAM in GB
    6. Is Tivoli common agent exists in laptop/desktop
    7. Internet explorer vesrion
    8. Whether MS Office 2003  is installed?
    9. Whether MS office visio professional is installed?
    10. Whether MS Project 2003 is installed?
    11. SBC number(Don't know whether we can get this number thru scripting.It is actually present on the barcode.Don't know whether this information is stored in any registry/file )

    Thanks In Advance

    Kedara

    

     

All Replies

  • Tuesday, February 12, 2013 6:48 PM
     
     Answered
    Sign In to Vote
    0
    Have a look here: http://dieseyer.de/scr-html/hardwareinventur.html
     
  • Tuesday, February 12, 2013 7:17 PM
     
     
    Sign In to Vote
    0

    Thanks a lot and appreciate for the quick reply.

    I got empty excel file for the first time and when I try to execute the second time it gave me access permission denied and showing the line number 295 and aslo I am not able to delete the PC_Inv_NA.txt file.

    Thanks In Advance

     
  • Tuesday, February 12, 2013 7:42 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    This is not a support forum for the script in the link Oberwald posted. If you need help with that script, you need to ask the script's author.

    Bill