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.
Article Type
Technical Solution


Subject

Issue



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

Corrected stored procedure
wc_sel_license_info_sp5_corrected.sql (3 kBytes)
Original stored procedure
wc_sel_license_info_sp5_original.sql (3 kBytes)




Supplemental Materials

SourceETrack
Value2365653


Article URL http://www.symantec.com/docs/TECH158901


Terms of use for this information are found in Legal Notices