How do I find and view a TFS changeset by comment text?

With the Power Tools installed:

tf history $/ -r | ? { $_.comment -like '*findme*' }

You can use the command line client: pipe the output of tf history to a file and then use whatever search program you prefer.

I don't know a way to do it by Comment Text, but this will allow searching by developer:

If you open the menu item File->Source Control->Find In Source Control->Changesets... (you must be in Source Control Explorer for this to be available). This will open the Find Changesets dialog. You can then search for change sets by Developer on a given source folder (or project).

This will show you the comments, but you can't search by them. (Though you can sort the list by the comments and find the comment you are looking for that way.)

On a side note, if you want to see the details of the changeset via this dialog you have to click the Details button. Double clicking on a changeset closes the dialog.

To see the checkins for a team member:

In team explorer, navigate to the Team Project, navigate to Team Members, right click the team member for who you want to see the changesets, and select "Show CheckIn History".

I added tfpt searchcs from the TFS Power Tools as external tool in VisualStudio:

• Command: C:\Program Files (x86)\Microsoft Team Foundation Server 2015 Power Tools\TFPT.EXE (or wherever you installed your TFS Power Tools)
• Arguments: searchcs /collection:http://tfsserver:8080/tfs $(SolutionDir) (the solution path is converted to the server path)
• Initial Directory: c:\path\to\your\vs\IDE (unless the tf.exe is in your path (what is not the case by default) this ensures you can view the changeset details from the search dialog, for it runs tf.exe)