When trying to select a Resource Type under Configuration tab > Server Settings > Discovery Methods > Add Resource, the following error occurs:
Server Error in '/Altiris/Resource' Application.
Invalid object name 'dbo.fnAssetGuidListToTable'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'dbo.fnAssetGuidListToTable'.
The function "fnAssetGuidListToTable" is is installed with Asset Control Solution. Before R4, the edit resource page never called this function. R4 introduced a modification that calls this function to correct a bug with Asset Control. If Asset Control is not installed, you will get the invalid object error.
This issue is resolved in Roll-up 6 (R6) for Notification Server 6.0 SP3.
Release notes can be found at: https://kb.altiris.com/article.asp?article=34317&p=1
Notification Server 6.0.6074 SP3
Update KB27859 (R4) or KB31946 (R5)