<?php

$rootPath = dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR;
require_once $rootPath . 'app' . DIRECTORY_SEPARATOR . 'Mage.php';
Mage::app();
$shopping_cart_rules = Mage::getResourceModel('salesrule/rule_collection');
echo "<pre>";
foreach ($shopping_cart_rules as $rule) {
    echo "RULE ID:" . $rule->getRuleId()."<br/>";
    echo "coupon code ID:" . $rule->getCode()."<br/>";
    echo "Simple free shipping:" . $rule->getSimpleFreeShipping()."<br/>";
}
echo "</pre>";

<?php

$rootPath = dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR;
require_once $rootPath . 'app' . DIRECTORY_SEPARATOR . 'Mage.php';
Mage::app();
$shopping_cart_rules = Mage::getResourceModel('salesrule/rule_collection');
echo "<pre>";

foreach ($shopping_cart_rules as $rule) {
    if( $rule->getSimpleFreeShipping()==1):
         echo "coupon code ID:" . $rule->getCode()."is used for free shipping<br/>";
    endif;
}
echo "</pre>";