question

DucheminDominique-7551 avatar image
0 Votes"
DucheminDominique-7551 asked saldana-msft edited

Client0 Values?

Hello

Select DISTINCT SYS.Client0, Count(*)
From v_R_System SYS
Join v_FullCollectionMembership COL on COL.ResourceID = SYS.ResourceID
Where COL.CollectionID = 'UCP0001F'
Group By SYS.Client0

System Resource - Client equal 1
System Resource - Client Version is Null
System Resource - Client Version is Not Null

Client0 (No column name)
NULL 341
0 38
1 258

Is it normal? Should I have 3 values NULL, 0, 1 or should it be only two values NULL & 1?
NULL ==> No Client
1 ==> Client installed
what does 0 mean?

Thanks,
Dom

mem-cm-generalmem-cm-site-deployment
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GarthJones-MVP avatar image
1 Vote"
GarthJones-MVP answered

Yes it is normal 0 = no client.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DucheminDominique-7551 avatar image
0 Votes"
DucheminDominique-7551 answered

Hello,

Thanks Garth,
What is the difference between Clients having Client0 = 0 and Client0 = NULL.
For the testing of existing client to be able to receive deployment and non-existing client which needs a client to be installed should I test Client0 = 0 (38 items) or Client0 = NULL (341 Items)...

Thanks,
Dom

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GarthJones-MVP avatar image
1 Vote"
GarthJones-MVP answered

You should be testing for both 0 and null.
There is no real difference between them, 0 "generally" means that the client was uninstalled.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HanyunZhu-MSFT avatar image
0 Votes"
HanyunZhu-MSFT answered

Hi, @DucheminDominique-7551

Just check in if there is any update. Did you get any result after the test? Do you need any further assistance? If so, please don't hesitate to let us know.

If the problem is solved, click Accept Answer and upvote the response that helpful to you.

Look forward to hearing from you. Thanks for your time.

Best Regards
Alan

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.