Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jm2
  • Order by date
  1. jm2

    software inventory table size problem?

    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...
  2. jm2

    Query dilema/need suggestions

    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...
  3. jm2

    SMS 2.0 - Any known issues with Dell PC's

    we have a user community with Dell gx1, gxi, gxl as well as hp vextra and kayak. The Dells have presented no problems what so ever.
  4. jm2

    Machine Name Changes

    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.
  5. jm2

    SMS Snap Shot Utility

    My organization currently uses Lanovation's Picture Taker product and have found it to be extremely versatile. Might be worth investigating.
  6. jm2

    Data Export/Reports in SMS 2.0

    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...
  7. jm2

    Query dilema/need suggestions

    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 &quot;bmhcc_stdver&quot;<br> <br> 2). excludes all pc's that have another environment variable, in this case bmhcc_stdver !=&quot;3.2&quot;<br> <br> 3)...

Part and Inventory Search

Back
Top