Everybody has a notebook or a laptop computer now. Machine Name, User Title, Pc Producer, Laptop Type (i.e. Desktop or Laptop, and so forth), Asset Tag and Serial Number. Use the SQL script beneath to gather OLE DB information source Linked Server Info. The laptops have 2.5 inches Laborious disk drive which is one inch less than the standard desktop pc’s hard disk.
This question will show you the entire Useful resource Varieties obtainable to the SMS database. Here you will find a SQL question to list SMS shopper resources which have generated new SMS ID’s along with their Useful resource ID and the timestamp that the change was generated.
This SQL question will return all of the machines that have USB Disk Drives along with the last logged on consumer title. In five quick steps as the photographs on the location, my notebook learn the info from my hard drive, which has been turned dinamic to Basics with this free software program.
The smallest ultraportable is sometimes referred to as sub-notebooks having 10-inch shows and confined keyboards. This SQL query will search Add and Remove Packages and return the machines and last logged on consumer identify that has a specified application (Display Title) and Version installed.
This SQL script will depend the Producer and Fashions for the assets in your SMS database for reporting purposes. Included will be the Machine name, Useful resource area identify, Login user ID, the account use domain, user’s full identify, serial number, producer, mannequin and the machines assigned web site.
This SQL question very like its counterpart in the SMS console will provide you with the part status for you site. You will need to additionally word right here that this is not a Microsoft supported means for deleting machines from the SMS database and should be utilized in a non production setting.