Re: SMS collection query help please

the query should work aok, only difference i can see from one i just
looked at is that mine doesn't use the brackets to enclose the
conditional statement, even so that won't cause any issues.

Do an update\refresh on the offending collection, see if the content
changes. and close\reopen the sms console.

if the parent collection has clients that meet both criteria then
cannot see how that could be causing this.

On Sun, 10 Dec 2006 20:05:00 -0800, UnderCoverGuy
<UnderCoverGuy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hello all,

I am trying to populate a collection in SMS 2003 and I am having issues. I
have set a query to inventory for both a files existence and a files size on
a users' workstation to determine if an upgrade is needed (file TEST.EXE not
6291456 bytes in size). The query statement is:

-----------
select
SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client
from SMS_R_System inner join SMS_G_System_SoftwareFile on
SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where
(SMS_G_System_SoftwareFile.FileName = "Test.exe" and
SMS_G_System_SoftwareFile.FileSize != 6291456)
-----------

The above collection query works just fine to tell me whether the file
TEST.EXE is not 6291456 in size. Based off of the working of the above, I
want to also create another collection and populate it with systems that have
received the upgrade. Basically, the same as the previous, but populate this
collect if the file TEST.EXE is 6291456 bytes in size. The query that I am
using is:

-----------
select
SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client
from SMS_R_System inner join SMS_G_System_SoftwareFile on
SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where
(SMS_G_System_SoftwareFile.FileName = "Test.exe" and
SMS_G_System_SoftwareFile.FileSize = 6291456)
-----------

The above query populates the collection with the exact same systems that
are in the first collection. These are each a seperate sub-collection of a
parent collection. The first uses a NOT equal (!) and the second one doesn't.

Does anyone have any thoughts on this? Any help would be appreviated.


Thank you,
UCG
-

Rob - Windows Management User Group

www.wmug.co.uk
.

Relevant Pages

  • Passing 2 parameters to stored query?
    ... query from a form. ... populate the variables then open the query it ... Set rst = New ADODB.Recordset ... Do Until CalcDate = Me.txtDateTo ...
    (microsoft.public.data.ado)
  • RE: Data entry property & lookup
    ... Dave Hargis, Microsoft Access MVP ... most recently entere record. ... the most recently entered or you can add a date/time stamp field and populate ... I had put an unbound combo box in but didn't set the query up ...
    (microsoft.public.access.forms)
  • Re: Hard to explain - multiple update fields query...
    ... "John Spencer" wrote: ... query to get the data back into the AwardsTable ... AwardsTable in your Access database and do all the work there. ... You will need 40 queries to populate the table from your current table. ...
    (microsoft.public.access.queries)
  • Re: create and/or insert into a table, specifying columns once
    ... >have to create a query that comes up with all of the columns in two places: ... >first to create a new table and then to populate an existing table. ... for all iterations. ... I see no reason to prefer the third or fourth option over this. ...
    (microsoft.public.sqlserver.programming)
  • Passing a value from one form to another
    ... 10 labels and a control array of say 10 buttons. ... This part of it works fine, please do not see this as a DB query. ... hide my 1st form and populate the control array of labels on this 2nd ... from the ID that is stored in the relevant button's tag. ...
    (microsoft.public.vb.enterprise)
Loading