Difference between revisions of "User:Pgmurphy/WCA"
Jump to navigation
Jump to search
| (One intermediate revision by one other user not shown) | |||
| Line 43: | Line 43: | ||
** Currently, data is processed in alphabetical order. This means that if two or more data files from the same computer are in the collected data share, the oldest entry will be processed last, overwriting newer data. | ** Currently, data is processed in alphabetical order. This means that if two or more data files from the same computer are in the collected data share, the oldest entry will be processed last, overwriting newer data. | ||
* Add change tracking to flag new, missing, and changed data. | * Add change tracking to flag new, missing, and changed data. | ||
| + | * Collect users that have logged on to this computer and last logon timestamp. | ||
| + | *Add in OU location data to allow for customized views in MySQL. | ||
Latest revision as of 16:13, 10 June 2008
WolfTech Collector Agent 2.0
Client
WolfTech Hardware Info Collector Agent
- Collects information about hardware from WMI.
- Task is scheduled to run every 1 hour at a random selected minute.
- Data is only generated every 7 days.
- Last runtime stored at HKLM\Software\WolfTech Collector Agent\HWLastRun
WolfTech Software Info Collector Agent
- Collects information about installed software from HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall.
- Task is scheduled to run every 1 hour at a random selected minute.
- Data is only generated every 7 days.
- Last runtime stored at HKLM\Software\WolfTech Collector Agent\SWLastRun
WolfTech Collector Transfer Agent
- Transfers collected data to the collector file share.
- Task is scheduled to run every 1 hour at a random selected minute.
Server
Data Processor
- Processes the data uploaded to the collector file share by inserting it into mdb3.wca_hardware and mdb3.wca_software.
- Results are logged in mdb3.wca_log.
- Task is scheduled to run every 10 minutes.
Cleanup
- Deletes collected data older than 7 days old. Data is archived for 7 days for debugging purposes.
- Task is scheduled to run every 1 hour.
Release Notes/Planning
1.0
- Initial release.
2.0 (release)
- Replaced Application Compatibility Toolkit software inventory tool with custom VBScript.
- MS-SQL free.
- Merged hardare and software data processor into 1 script.
- Data processing now done every 10 minutes.
- Removed domain name from data.
- Added wca_log table to log data processing.
3.0 (in planning)
- Change collection interval to every 3 days.
- Fix bug in data processor that could allow old data to overwrite newer data.
- Currently, data is processed in alphabetical order. This means that if two or more data files from the same computer are in the collected data share, the oldest entry will be processed last, overwriting newer data.
- Add change tracking to flag new, missing, and changed data.
- Collect users that have logged on to this computer and last logon timestamp.
- Add in OU location data to allow for customized views in MySQL.