The officer never would have had probable cause for a warrant for this individuals information though, since he didn't even work at the sites that had the missing/tampered drugs.
Sure, obviously the warrant would likely be far more limited in scope (i.e. only people that had access to the drugs at the time), but the same scenario is certainly still possible.