Archiving old Catalog requests

[Patrick_Price_10294]

Good day,

I need to archive old Catalog requests from my MDB. This is the query from the techdoc for archiving requests. It does nothing. Can anyone please help?

USE mdb
GO
DECLARE    @return_value int
EXEC    @return_value = [dbo].[usm_sp_archive_data]
        @p_object_type = 'Request',
        @p_date = '2017-03-31',
        @p_bu = 'xxx Municipality'

SELECT    'Return Value' = @return_value
GO

-------------------------------------------

[Paul Coccimiglio]

Patrick..........

Are you referring to the following documentation:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-4/administering/administering-ca-service-catalog/archive-and-purge-historical-data.html

If so, I think there are some syntax errors in the query you are trying to run.

Please try the following:

USE mdb
GO
DECLARE    @return_value int
EXEC    @return_value = [dbo].[usm_sp_archive_data]
        @p_object_type = N'Request',
        @p_date = N'2017-03-31',
        @p_bu = N'xxx Municipality'

SELECT    'Return Value' = @return_value
GO

------------------------------
Paul Coccimiglio
[JobTitle]
[CompanyName]
------------------------------