Magento 1.9.3.2 missing product images

Question

I have noticed in my backend that some products have broken image links. Thus, placeholder gets used on frontend.

I would like to get a list of products that has the placeholder as it's image on the frontend. I have written the following, but it is not working correctly:

    <?php 
error_reporting(E_ALL);
ini_set('display_errors', '1');

require_once('app/Mage.php');
Mage::app();

error_reporting(1);
set_time_limit(0);
ini_set('memory_limit', '2048M');

$_products = Mage::getModel('catalog/product')
    ->getCollection()
    ->addAttributeToSelect('*')
    ->addAttributeToFilter('visibility', 4)
    ->addAttributeToFilter('status', 1);

foreach($_products as $_product){
    if($_product->getImageUrl()){
        echo($_product->getImageUrl(). $_product->getSku()."</br>");
    }
}?>

Update of new code I have tried:

    <?php 
error_reporting(E_ALL);
ini_set('display_errors', '1');

require_once('app/Mage.php');
Mage::app();

error_reporting(1);
set_time_limit(0);
ini_set('memory_limit', '2048M');

$_products = Mage::getModel('catalog/product')
    ->getCollection()
    ->addAttributeToSelect('*')
    ->addAttributeToFilter('visibility', 4)
    ->addAttributeToFilter('status', 1);

foreach($_products as $_product){
    if (!file_exists(Mage::getModel('catalog/product_media_config') ->getMediaUrl( $_product->getImage()))) {
    echo $_product->getSku(). "<br/>";
}
        //echo(Mage::getModel('catalog/product_media_config') ->getMediaUrl( $_product->getImage())."</br>");

}?>

Still not doing what I need

Answer 1

Try below code.

foreach($_products as $_product){
    $allImages = Mage::getModel('catalog/product')->load($_product->getId())->getMediaGalleryImages();
    echo "Product ".$_product->getSku()."<br>";
    foreach($allImages as $_image){
        if (!file_exists($_image->getPath())) {
            echo "Missing Images <br>";
            echo $_image->getPath()."<br>";
        }
    }
    echo "<br>";
}

It will give you products with List of Missing Images. If there is no missing image, it will show only product sku.