KNOWN ISSUE: The DS Web Console's About page displays values for PDA's instead of for Clients.
| Article:TECH158901 | | | Created: 2011-04-27 | | | Updated: 2011-04-29 | | | Article URL http://www.symantec.com/docs/TECH158901 |
| NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made. |
Problem
The Deployment Server (DS) Web Console's About page displays values for PDA's instead of for Clients.
Environment
DS 6.8 and later, and even possibly earlier.
Cause
When the DS Web Console’s About page loads, it runs the wc_sel_license_info stored procedure in order to obtain the data it needs to display. Reviewing this stored procedure will find that the “select count” queries for client and pda are configured with each others node_type instead of their own node_type.
--2
select count (computer_id) as client from computer where (limited_license = 0) and
node_type = 2 and (( prod_name not like '%hp t5%' and prod_name not like '%futro%' ) or
prod_name is null) and computer_id not in (select computer_id from nics where
mac_addr is null)
--3
select count (computer_id) as pda from computer where (limited_license = 0) and
node_type = 3 and (( prod_name not like '%hp t5%' and prod_name not like '%futro%' ) or
prod_name is null) and computer_id not in (select computer_id from nics where
mac_addr is null)
The node_type table contains the following information:
1 Server
2 PDA
3 Client
Solution
To correct this problem, the node_type values for these queries need to be changed to reflect their true values.
The corrected stored procedure is attached - wc_sel_license_info_sp5_corrected.sql
The original stored procedure is also attached for rollback purposes - wc_sel_license_info_sp5_original.sql
Attachments
|
|
|
|
|
|
|
|
| Source | ETrack |
| Value | 2365653 |
Article URL http://www.symantec.com/docs/TECH158901
Terms of use for this information are found in Legal Notices









Thank you.