how to get Mac Address in SSRS

  • Hi,

    I am having a requirement of taking the MAC Address using SSRS is it is possible to take?

    My Requirement:

    To take and keep the mac address of each user and make a note that he does not make double entry of comments ,there is no log restriction like using userid and password , just to access the page and user will give some comments.

    Other than MAC Address can we do this?If so how to find the uniqueness on the users.

    Notes:

    A user should not have double entry.No user is provided Userid and password.

    Thanks!

  • yuvipoy (2/27/2013)


    Hi,

    I am having a requirement of taking the MAC Address using SSRS is it is possible to take?

    My Requirement:

    To take and keep the mac address of each user and make a note that he does not make double entry of comments ,there is no log restriction like using userid and password , just to access the page and user will give some comments.

    Other than MAC Address can we do this?If so how to find the uniqueness on the users.

    Notes:

    A user should not have double entry.No user is provided Userid and password.

    Thanks!

    Directly in an SSRS report? No. SSRS is a read-only reporting tool. Whilst it might be technically possible to log data via a stored procedure, it is not designed for doing that.

    If you create a .NET website and embed a report viewer control in it, then the page itself could make use of an active X object to log a user's MAC address.

    I think you should look at the log tables in the SSRS database. Assuming all your users have their own windows login names on your domain then they will all be logged individually for each time the run a report. Look at the [Catalog] table and the [ExecutionLog] table.

    "A user should not have double entry.No user is provided Userid and password."

    If users in your domain are not logging in with unique usernames and passwords then you have some serious security issues. I suppose you are talking about sql server authentication, but that doesn't matter. The SSRS log tables record the report user. If you want to set up anonymous access to reports then I strongly recommend against using some generic sql server authentication user for the datasource connection. You are better off adding a read-only windows authentication group to your datasource (I'm assuming it's SQL Server) and adding everyone to your domain to that group.

    How are you planning for users to make comments? SSRS does not have write-back functionality so you would have to manage that yourself in .NET.

    It would really help your question if you explained more about your setup and why you need to do this because it doesn't seem like a good idea.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply