I would recommend to utilize extended events if you are able to capture the information you need.
There is code on MS SQL Tips written by Svetlana Golovko which will probably resolve the problem for you. I have included a copy of her code below, but please follow the link above for the full explanation. Her information on the extended events is at the very bottom.
Creating the extended event session.
CREATE EVENT SESSION [EXEC_SP] ON SERVER
ADD EVENT sqlserver.sp_statement_completed(SET collect_object_name=(1),
collect_statement=(0)
ACTION(sqlserver.client_app_name,
sqlserver.client_hostname,
sqlserver.database_id,
sqlserver.database_name,
sqlserver.username)
WHERE (([object_type]=(8272))
AND ([source_database_id]=(9)))) -- replace with your database ID
ADD TARGET package0.asynchronous_file_target
(
SET FILENAME = N'E:\DBA_Audit\SP_Exec.xel',
METADATAFILE = N'E:\DBA_Audit\SP_Exec.xem'
);
GO
ALTER EVENT SESSION [EXEC_SP] ON SERVER
STATE = START;
GO
--https://www.mssqltips.com/sqlservertip/3259/several-methods-to-collect-sql-server-stored-procedure-execution-history/ By Svetlana Golovko
Viewing data from the extended event session.
;WITH ee_data AS
(
SELECT data = CONVERT(XML, event_data)
FROM sys.fn_xe_file_target_read_file(
'E:\DBA_Audit\SP_Exec*.xel',
'E:\DBA_Audit\SP_Exec*.xem',
NULL, NULL
)
),
tab AS
(
SELECT
[host] = data.value('(event/action[@name="client_hostname"]/value)[1]','nvarchar(400)'),
app_name = data.value('(event/action[@name="client_app_name"]/value)[1]','nvarchar(400)'),
username = data.value('(event/action[@name="username"]/value)[1]','nvarchar(400)'),
[object_name] = data.value('(event/data[@name="object_name"]/value)[1]','nvarchar(250)'),
[timestamp] = data.value('(event/@timestamp)[1]','datetime2')
FROM ee_data
)
SELECT DISTINCT [host], app_name, username, MAX([timestamp]) as last_executed,
COUNT([object_name]) as number_of_executions, [object_name]
FROM tab
GROUP BY [host], app_name, username, [object_name] ;
--https://www.mssqltips.com/sqlservertip/3259/several-methods-to-collect-sql-server-stored-procedure-execution-history/ By Svetlana Golovko