I am trying to add one criteria to a already working query. That criteria is software filename ="iexplore.exe". If I show values of this criteria while in the query design tool, the list is obviously short..... We inventory for several different extensions and the table is probably...
I received the answer to this dilema from Dave Yarbrough. The correct way <br>
to do this is via subselect query. Here is how you do it<br>
1). Create a query that finds all system names that HAVE the file in <br>
question. Name it something like HAS pet.xls<br>
2). Create a second query. Use...
SMS automatically creates a delta file which is refreshed with every software and hardware inventory. This delta file is sent to the database to refresh the data.
I have been cautioned that using access via SQL ODBC link is not supported, but I have been able to do some great reports this way. Specifically workstation recovery, a count of all pc's software(prompted) is loaded on... Then I utilized excel 2000 to create a series of web pages that can be...
I am developing a query that looks for the following criteria:<br>
<br>
1). looks for the presence of an environment variable, in this case "bmhcc_stdver"<br>
<br>
2). excludes all pc's that have another environment variable, in this case bmhcc_stdver !="3.2"<br>
<br>
3)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.