To know which applications or processes are using a DLL from the Command Prompt, use TASKLIST command with the following syntax.
tasklist /m [module]
For example, running the following command will list all applications that are using the ADVAPI32.dll:
tasklist /m ADVAPI32.dll
[Update 2023-07-20] Output in Windows 11:
Note: To open the Command Prompt, go to Start > Run. Then type CMD and hit Enter.