I think I have found an answer to my own question.
Just spotted - OS - NT Info - Install Date.
This looks pretty spot on for what I need.
ACCEPT the field is a text field, not a date field... hmmmm.
Yeah - unfortunately it's not a very nicely formatted item that can be thrown at a DATETIME value for SQL.
Chances are this is a historical thing (bear in mind that we've had to deal with Windows 95/98 data as well back in the day), so I'd expect it to be one of those historical burdens that it couldn't be sensibly be converted into a DATETIME value in some sensible fashion.
What you CAN do is to grab the values of the field (OSNT-table, InstallDate column) and throw them through a script if need be.
How complex is your query / question against the data?
I have managed to put together a rather crude query like this. It does return what I want but I also get a few entries I need to exclude too which I can do easy enough.
It is not a problem though. One of our managers was just fishing for information.
Here is the query I created. This was to retrieve all devices imaged in September.
I told you it was crude but I get the info I want.
That'll do well.
I'd personally just question the use of orange as a colour scheme .
But yeah - that sort of query is why we added the "Multi-insert" button ... and it should all be fast since you're using the = operator. So yeah - well done, sir!
Hey, don't dis the orange
Orange you glad I spotted it? .