https://www.dualshockers.com/agent-trademark-abandoned/amp/

"According to the update on the trademark, which can be viewed here, the agency says that the trademark was abandoned due to there being “no Statement of Use or Extension Request timely filed after Notice of Allowance was issued,” which essentially means Take-Two did nothing with it. Of course, this should come as no surprise, as Rockstar has basically never commented on the game in an official capacity in the past 11 years. Frankly, the only place in 2018 where you can find mention of it on an official basis is a small page on both Rockstar Games and Take-Two’s websites."

It's dead jim! This was meant to save the PS3. I guess it ain't getting saved now. It's over. The Wii has won!

Edit: It's still listed, the last hope!

https://www.rockstargames.com/games/info/agent

Wii: It's over PS3, I have the high ground!!

Oh wow, I totally forgot this was a thing.

The game was probably never in mass production so the concept may as well have never existed as well ...

Wasn't it rumoured they came to a deal that in return for Rockstar not making this game, Sony would get the exclusive advertising to the next GTA and Red Dead instead? 

I also forgot about it. Maybe they even had something in development but got cancelled.

Shame, I always want more games from rockstar. They are simply amazing.

Nothing will ever come of it so best not to speak about it anyways ... 

Good grief, i'm glad i already heard of this upcoming game, i would've disappointed if i was excited in the first place.

Crazy enough they just showed logos and talked about it since E3 2009, overall you got nothing.