Currently i have a vbs script that logs pc details everytime its booted to ad/a csv file. I was thinking about altering this to read/write to a database file (sql probably) the idea being that with extra fields the database i could then do better reporting etc on it ? so for instance write a web interface to look data up/filter it, hopefully grab warranty info and fill in a field by each pc it can find with expiration dates, realise that no 2 pcs have the same mac address and merge records so that if i rebuild pc1 and call it pc01 it knows pc01 is newer and remove pc1 BUT add pc1 to an old names field, ercord historical data so if i add more ram it can as well as recording that pc01 now has 8gb ram it logs the fact before that it had 4. I suspect the easiest way to do this would be just to give each mac address its own table and as things change add a new row in the table. Granted i have almost no idea where to start but any advice is appreciated. Presumably i could do multiple linked tables as well so that forr mac address x i have a a table with specs, a table showing diference in drive usage, users who have used it possibly, and a separate table or warranty info
Same as Soviet really, we've got a custom style one that does similar.
Things I'd say though, Personally I'd go with a service tag if your pc makes have one. Generally easier to log information against certain computers etc. Also no worries if you have multiple cards/wireless, and/or any motherboard swaps etc if it ever dies.
Depending how often you want it to update, you could either keep updating one record for each pc (But won't give you new data), or set an "active" switch for filtering, so you can filter it out for current pcs, but search for older ones.
service tags are generally dells arnt they? i have very few dells except servers. Its mainly hp/fuji/lenovo. I have the majority of the fields already for example i just pulled the csv for a netbook (it gathers it every bootup)
well yes by the same token i could use spiceworks but its as much for a challenge that gets something done as for the result itself and if ive designed it i can get it to output exacly what i want how i want
We do this using a VBS script which gathers various bits from the client using WMI and then invokes cURL to send the data to a PHP script, where it gets entered into a SQL table. The script is in a GPO to execute every time a machine boots. It works well, giving us very current data that can be joined to other queries for reporting - it is this aspect that would be more difficult to achieve with System Centre etc. only. I also make use of Dell's API to retrieve warranty info based on the Service Tag.