CA Client Automation

  • 1.  Query DSM - Serial Number Field

    Posted May 30, 2016 02:41 PM

    Hello guys,

    Please does anyone know what query can use the DSM to bring the machines to the value of the serial number field value = (Null) or (White)

    Thanks.



  • 2.  Re: Query DSM - Serial Number Field
    Best Answer

    Posted May 31, 2016 03:46 AM

    Hi Alex,

    you can create your own query to get all the machines without a Serial Number

     

    - on the DSM go to the Query folder
    rigth click and select new, select "Computers" and click OK
    on the next widows open the tree "insert argument" / "General Information" / "computer" and select "Serial Number" on the botom let the first entry with the value "=" and  select on the combo list the empty value

    on he "Boolean Operator" select "Or" and do the same for the value "N/A" and "Not Available" or any other you wich displayed?

    click on "preview" to see the results or save and and run the query

     

    - with the mssql query you can run something like
    use mdb
    SELECT * FROM ca_discovered_hardware WHERE serial_number is null or serial_number = '' or serial_number = 'N/A' or serial_number = 'Not Available'

     

    regards,
    Antonio



  • 3.  Re: Query DSM - Serial Number Field

    Posted May 31, 2016 07:00 AM

    Hi Antonio,

    Thank you very much!