Through software inventory report, I understand that an application(for eg,Microsoft Office) is installed in 500 machines. However,I want to understand whether this application is really getting used by all 500 users or not. How can I get this data?

Yes, you can get the software usage information using software metering on Windows. You will have to configure software metering rule for this application software to track. Please refer Software Metering to configure.