Welcome to the Blogcast Repository Sign in | Join | Help
Search BlogCastRepository.com for:
in Search

254 BlogCasts in The BlogCast Repository!

Inventory Report

Last post 08-07-2007 3:32 AM by Abhishek Joshi. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 08-02-2007 8:54 PM

    • nellie2
    • Top 25 Contributor
    • Joined on 02-09-2007
    • Posts 87
    • Points 1,310

    Inventory Report

    Hello there,

        Do you have any idea what view and what column in the REPORT SQL STATEMENT will I be using to get the SERIAL NUMBER of the computer or motherboard? I am making a custom report that gets the specifications of the computer.

    Thanks and best regards.

     

    nels
    • Post Points: 20
  • 08-04-2007 3:35 PM In reply to

    Re: Inventory Report

    u can use for serial number of PC v_GS_PC_BIOS and u can use column name SerialNumber0 and for motherboard v_GS_MOTHERBOARD_DEVICE
    Thanks and Regards
    Abhishek Joshi | SMS 2003/SCCM2007 certified,ITIL Foundation
    http://blogcastrepository.com/blogs/abi/default.aspx
    Filed under: ,
    • Post Points: 20
  • 08-07-2007 1:35 AM In reply to

    • nellie2
    • Top 25 Contributor
    • Joined on 02-09-2007
    • Posts 87
    • Points 1,310

    Re: Inventory Report

    thanks. i already found it.Guess just needs to browse more.
    nels
    • Post Points: 20
  • 08-07-2007 3:32 AM In reply to

    Re: Inventory Report

    http://www.microsoft.com/technet/prodtechnol/sms/sms2003/customreports/9a0d62fa-d8d5-4a26-b772-18cac737e67e.mspx?mfr=true

     
    u can go through above link(might be u know bout this)..... this has all references of SQL views.... might be this will help u and it will reduce ur time to search a views. :)

     

     

    Thanks and Regards
    Abhishek Joshi | SMS 2003/SCCM2007 certified,ITIL Foundation
    http://blogcastrepository.com/blogs/abi/default.aspx
    Filed under: ,
    • Post Points: 5
Page 1 of 1 (4 items)