https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?action=history&feed=atom&title=VEhub_Support 2026-07-01T08:51:00Z Revision history for this page on the wiki MediaWiki 1.39.8 https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=VEhub_Support&diff=11480&oldid=prev 2025-02-28T15:01:27Z

<p>Initial Creation</p> <p><b>New page</b></p><div>This page identifies common support tasks and resolutions<br /> <br /> == Requirements ==<br /> * SQL Server Management Studio<br /> * Access to SharedWeb database<br /> <br /> <br /> == Updating Admin and PDA users ==<br /> * Open the right database on SharedWeb e.g. VEHUB_NEW<br /> * Find the customer<br /> SELECT TOP 1000 [Id]<br /> ,[CustomerCode]<br /> ,[CustomerName]<br /> ,[Address1]<br /> ,[Address2]<br /> ,[Address3]<br /> ,[Country]<br /> ,[Postcode]<br /> ,[TotalBackOfficeLicenses]<br /> ,[TotalPDALicenses]<br /> ,[ModifiedBy]<br /> ,[ModifiedDate]<br /> ,[CustomerImageSrc]<br /> FROM [VEHUB_NEW].[dbo].[Customer]<br /> where customerName like '%partialCustName%'<br /> * Note the customer ID.<br /> * Edit Customer record and change these values:<br /> ** [TotalBackOfficeLicenses]<br /> ** [TotalPDALicenses]<br /> <br /> UPDATE [VEHUB_NEW].[dbo].[Customer]<br /> SET [TotalBackOfficeLicenses] = x<br /> , [TotalPDALicenses] = y<br /> WHERE CustomerId = z<br /> <br /> <br /> [[Category:VEhub]]</div>

Anw