Its a bug when updating an audit (admin_pc_add_2.php line 769, admin_pc_add_dir.php line 748)
Shouldn't the details be updated on the partition_caption field instead of the partition_device_id field, as the partition_device_id is not unique
The number of results returned from Win32_DiskPartition may be less then the number of results from theWin32_LogicalDisk, ie many logical disks to one disk partition.
When updating an audit ....
partition^^^True^^^True^^^Disk #0, Partition #1^^^0^^^94^^^True^^^C:^^^NTFS^^^2873^^^45284^^^NoBackup^^^
partition^^^False^^^False^^^Disk #0, Partition #0^^^0^^^53^^^False^^^D:^^^NTFS^^^11764^^^25007^^^System^^^
partition^^^False^^^False^^^Disk #0, Partition #0^^^0^^^23^^^False^^^E:^^^NTFS^^^19329^^^25093^^^Development^^^
get translated into
UPDATE partition SET partition_timestamp = 'newtimestamp', partition_free_space = '2873'
WHERE partition_device_id = 'Disk #0, Partition #1 ' AND partition_uuid = 'system_name'
AND partition_timestamp = 'timestamp'
UPDATE partition SET partition_timestamp = 'newtimestamp', partition_free_space = '11764'
WHERE partition_device_id = 'Disk #0, Partition #0 ' AND partition_uuid = 'system_name'
AND partition_timestamp = 'timestamp'
UPDATE partition SET partition_timestamp = 'newtimestamp', partition_free_space = '19329'
WHERE partition_device_id = 'Disk #0, Partition #0 ' AND partition_uuid = 'system_name'
AND partition_timestamp = 'timestamp'
In this case the last two updates both modify two records
|