Client0 Values?

Question

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

Answer 1

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

Answer 2

Yes it is normal 0 = no client.

Answer 3

Hi, @Duchemin, Dominique

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

Answer 4

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