Technology
Technology
MSSQL NOTE – retrieving rows less than 90 days old
February 14, 2012 | 
Author Selecting inventory records from an inventory database, I only want records for computers that have been scanned in the last ninety days.
Simply solution using DATEDIFF
SELECT * FROM [inventoryt table]
WHERE (DATEDIFF([DAYOFYEAR], [LastScanDate],GETDATE()))< 90
HP DDMi – poking under the hood
Currently working with DDMi 9.3 or, PDI version 7.6
Delivering license compliance using HP DDMi : Getting the raw data Read the rest of this entry »
Fixing Dell AIO 922 on Windows 7
My junior tech upgraded a few desktops in the office to Windows 7. This instantly broke a number of things, one of which was the DELL all-in-one printer-fax-scanner. Microsoft Windows 7 drivers do not work for this scanner device (surprise surprise).
To get this working under Windows 7.
- Unplug the device and remove the printer and the drivers.
- Goto the DELL support site and download the R166239.zip file.
- Unzip and run the application.
- Restart the computer.
- Download and install the driver and application R151371.exe
- Plug the device back in
- The install will complete and you’ll have a nice scan application which works.
