Re: IBM/Lenovo Serial Number and Model Type

Hi Sherry,

Both applications are very small executables <20K each that can be set as scheduled tasks to run at any time using any standard Windows scheduler.

The results data files end up in the same root folder from where the executable is file is loaded and run. No user intervention is required.

The licensing we offer (flat fee per organization irrespective of how many PCs exist) for the hardware inventory enables the executable to be loaded on each machine and can be set to run at any time the system manager wants to gather the data eg; every 3 or 6 months rather than via daily log files etc. The patch file audit is free of charge.

The resultant hardware audit and patch results files are unencrypted text files so as to enable loading to any database and can be extracted off the local PC at any point in time so that bandwidth degradation or server utilization loads permit. The tools are not interactive and can be set to run and deliver the results on demand or at defined intervals that are prescribed in your own scheduler (note we do not have a scheduler inbuilt). No user manuals, training or whitepapers exist as they are really very basic and fast engine room tools focused on specific data outcomes.

We also offer similar "engine room" text and csv audit results for software inventory without using any database or software identification library or registry data. We ignored the registry for software inventory as the results can be unreliable for a number of reasons when using the Add/Remove (Registry Uninstall) area or looking at data generated from applications installed using MSI as not every vendor uses MSI as the application installer.

We wrote these audit tools many years ago (we started auditing PCs in 1991) and have continually tweaked them to suit auditors who didn't want large audit data files daily, weekly monthly,and didn't want encrypted data so they could massage and interpret, and didn't want to set up MOF files to collect information. Auditors that we work with wanted small and fast tools they could use to "hit and run" without impeding servers and systems and gather the results so they could use the results offsite in larger database consolidation systems, at their leisure.

The end results of these tools have now been used over and over again by sites as large as you describe and by some of the larger audit firms eg KPMG, E&Y etc for Y2K data gathering etc over the years and have been very useful to calibrate the accuracy and validity of other data inventory techniques. We have been auditing PCs since 1991 and have significant knowledge on the games and tricks that end users play with ways to beat the audit cycle and smokescreen the results!

Our approach has always been to offer fast, small in footprint size tools that are easy to use, require no training and work with minimal effort, and most importantly very low in license cost. The software inventory tool can be seen at http://www.pcprofile.com/auditbaselinev4.htm and can be scripted (we coach you to write the script) to run silent rather than as per the GUI based demo that is at that page.

These tools might be useful ways to enhance or free up your efforts with SMS so you can utilize resources better.

Regards

Rob Harmer
www.pcprofile.com

<sherrylkissinger@xxxxxxxxx> wrote in message news:1190066802.594676.252450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
(I'm not sure if my first post made it through, if this is a double-
post, I apologize).

Rob, does your utility you mention (or the one you mention in "Listing
Microsoft Patches and Fixes") integrate with Hardware Inventory for
SMS 2003 or System Center Configuration Manager? If so, please
provide a link to a white paper or online documentation on that
integration. I'd be very interested in that.

Otherwise, if these executables are only able to be run singly, since
the majority of people on this SMS list often have to manage thousands
of computers, an application that runs interactively, one machine at a
time, may not be a viable solution for most SMS / SCCM users.

On Sep 17, 4:54 pm, "Rob Harmer" <rhar...@xxxxxxxxxxxxxxxx> wrote:
Chris,

Is this what you are after? This is avery small executable we developed that
captures this information in a few seconds and can be run as a scheduled
task when required.

Computer System Details extracted from this PC:

Host Name: ROB-xxxxxxxxxx
OS Name: Microsoft© Windows VistaT Home Basic
OS Version: 6.0.6000 N/A Build 6000
OS Manufacturer: Microsoft Corporation
OS Configuration: Standalone Workstation
OS Build Type: Multiprocessor Free
Registered Owner: Rob
Registered Organization: Hewlett-Packard Company
Product ID:
Original Install Date: 22/06/2007, 12:43:39 AM
System Boot Time: 17/09/2007, 5:02:41 PM
System Manufacturer: Compaq-Presario
System Model: GF950AA-ABG SR5120AN
System Type: X86-based PC
Processor(s): 1 Processor(s) Installed.
[01]: x64 Family 15 Model 79 Stepping 2
AuthenticAMD ~2000 Mhz
BIOS Version: Phoenix Technologies, LTD 5.11 , 5/06/2007
Windows Directory: C:\Windows
System Directory: C:\Windows\system32
Boot Device: \Device\HarddiskVolume1
System Locale: en-au;English (Australia)
Input Locale: en-us;English (United States)
Time Zone: (GMT+09:30) Adelaide
Total Physical Memory: 3,006 MB
Available Physical Memory: 2,263 MB
Page File: Max Size: 4,891 MB
Page File: Available: 3,632 MB
Page File: In Use: 1,259 MB
Page File Location(s): C:\pagefile.sys
Domain: MSHOME
Logon Server: \\
Hotfix(s): 37 Hotfix(s) Installed.
[01]: KB925528
[02]: KB925902
[03]: KB929399
[04]: KB929451
[05]: KB929685
[06]: KB929735
[07]: KB929761
[08]: KB929762
[09]: KB929763
[10]: KB929777
[11]: KB930163
[12]: KB930178
[13]: KB930568
[14]: KB930857
[15]: KB931099
[16]: KB931174
[17]: KB931573
[18]: KB931621
[19]: KB933245
[20]: KB933579
[21]: KB936021
[22]: KB936782
[23]: KB938127
[24]: KB939159
[25]: KB928089
[26]: KB929123
[27]: KB929427
[28]: KB929916
[29]: KB930585
[30]: KB931213
[31]: KB931836
[32]: KB932246
[33]: KB933360
[34]: KB933566
[35]: KB935807
[36]: KB937143
[37]: KB938123
Network Card(s): 1 NIC(s) Installed.
[01]: NVIDIA nForce Networking Controller
Connection Name: Local Area Connection
DHCP Enabled: Yes
DHCP Server: 19x.xxx.1.1
IP address(es)
[01]: 19x.xxx.1.1
[02]: ef65::ec2a:2265:z49:5f21

++++++++++++END OF HARDWARE DETAILS REPORT FOR THIS PC+++++++++++++++++++

Regards

Rob Harmer
pcprof...@xxxxxxxxxxxxxxxx

"SMS_Chris" <SMSCh...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message

news:FBA447D2-442C-4FD2-9DAB-FF2BCEBFFC08@xxxxxxxxxxxxxxxx



> Hello,
> I am trying to compile an inventory report of a computer lab that > includes
> the IBM/Lenovo Serial Number and Model Type (all comps are IBM/Lenovo),
> and
> other info such as OS, hardware info, IP, etc. I'm really unfamiliar > with
> creating reports in SMS including SQL queries so if anybody could give > me
> a
> few pointers or references I would greatly appreciate it.

> BTW we are running SMS 2003 with a single site server with all advanced
> clients.

> Thanks!
> Chris- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Re: IBM/Lenovo Serial Number and Model Type
    ... of audit logs and speed issues' comment regarding sms. ... daily simple HW Inventory schedule; mgmt is OK with that daily schedule. ... that are prescribed in your own scheduler (note we do not have a ...
    (microsoft.public.sms.inventory)
  • Re: IBM/Lenovo Serial Number and Model Type
    ... How does your product enhance the data within SMS? ... scheduled tasks to run at any time using any standard Windows scheduler. ... PCs exist) for the hardware inventory enables the executable to be loaded ... The patch file audit is free of charge. ...
    (microsoft.public.sms.inventory)
  • Re: IBM/Lenovo Serial Number and Model Type
    ... query in SMS to gather the data vs using an off the shelf application? ... of their client sites had turned off the inventory aspects of SMS and used ... deployment only due to size of audit logs and speed issues. ... that are prescribed in your own scheduler (note we do not have a ...
    (microsoft.public.sms.inventory)
  • Re: IBM/Lenovo Serial Number and Model Type
    ... I guess the key question is how long does it take you write and test the query in SMS to gather the data vs using an off the shelf application? ... It came into being some time ago, pitched at auditors as they found some of their client sites had turned off the inventory aspects of SMS and used deployment only due to size of audit logs and speed issues. ... The tools are not interactive and can be set to run and deliver the results on demand or at defined intervals that are prescribed in your own scheduler. ...
    (microsoft.public.sms.inventory)
  • Re: Microsoft Software Auditing ?
    ... > wanted to inventory the software installed on the system. ... Overwritten executables will most likely be detected by ... script to do it, as the time invested would not really be worth it. ... but only if you want to detect malicious changes to the system. ...
    (Security-Basics)
Loading